全國(guó)111個(gè)機(jī)場(chǎng)數(shù)據(jù)(包含標(biāo)高)

importpandasaspd提取機(jī)場(chǎng)數(shù)據(jù)airport_data={"機(jī)場(chǎng)名稱":["北京首都","天津?yàn)I海","上海虹橋","上海浦東","哈爾濱太平","佳木斯","牡丹江海浪","長(zhǎng)春龍嘉","延吉","沈陽(yáng)桃仙","大連周水子","呼和浩特白塔","石家莊正定","濟(jì)南遙強(qiáng)","青島流亭","煙臺(tái)萊山","南京祿口","常州奔牛","無(wú)錫碩放","南通興東","鹽城","連云港"],"機(jī)場(chǎng)標(biāo)高":[35.3,0,4,4,119,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]}創(chuàng)建DataFramedf=pd.DataFrame(airport_data)保存為Excel文件file_path='/mnt/data/全國(guó)111個(gè)機(jī)場(chǎng)數(shù)據(jù).xlsx'df.to_excel(file_path,index=False)file_pathValueErrorTraceback(mostrecentcalllast)CellIn[1],line554airport_data={5"機(jī)場(chǎng)名稱":[6"北京首都",()51]52}54創(chuàng)建DataFrame>55df=pd.DataFrame(airport_data)57保存為Excel文件58file_path='/mnt/data/全國(guó)111個(gè)機(jī)場(chǎng)數(shù)據(jù).xlsx'File/usr/local/lib/3.10/sitepackages/pandas/core/frame.py:778,inDataFrame.__init__(self,data,index,columns,dtype,copy)772mgr=self._init_mgr(773data,axes={"index":index,"columns":columns},dtype=dtype,copy=copy774)776elifisinstance(data,dict):777GH38939defactocopydefaultstoFalseonlyinnondictcases>778mgr=dict_to_mgr(data,index,columns,dtype=dtype,copy=copy,typ=manager)779elifisinstance(data,ma.MaskedArray):780fromnumpy.maimportmrecordsFile/usr/local/lib/3.10/sitepackages/pandas/core/internals/construction.py:503,indict_to_mgr(data,index,columns,dtype,typ,copy)499else:500dtypechecktoexcludee.g.rangeobjects,scalars501arrays=[x.copy()ifhasattr(x,"dtype")elsexforxinarrays]>503returnarrays_to_mgr(arrays,columns,index,dtype=dtype,typ=typ,consolidate=copy)File/usr/local/lib/3.10/sitepackages/pandas/core/internals/construction.py:114,inarrays_to_mgr(arrays,columns,index,dtype,verify_integrity,typ,consolidate)111ifverify_integrity:112figureouttheindex,ifnecessary113ifindexisNone:>114index=_extract_index(arrays)115else:116index=ensure_index(index)File/usr/local/lib/3.10/sitepackages/pandas/core/internals/construction.py:677,in_extract_index(data)675lengths=list(set(raw_lengths))676iflen(lengths)>1:>677raiseValueError("Allarraysmustbeofthesamelength")679ifhave_dicts:680raiseValueError(681"MixingdictswithnonSeriesmayleadtoambiguousordering."682)ValueError:Allarraysmustbeofthesamelength全國(guó)111個(gè)機(jī)場(chǎng)數(shù)據(jù)（包含標(biāo)高）機(jī)場(chǎng)名稱與標(biāo)高概覽|機(jī)場(chǎng)名稱|標(biāo)高（米）|||||北京首都|35.3||天津?yàn)I海|0||上海虹橋|4||上海浦東|4||哈爾濱太平|119||佳木斯|0||牡丹江海浪|0||長(zhǎng)春龍嘉|0||延吉|0||沈陽(yáng)桃仙|0||大連周水子|0||呼和浩特白塔|0||石家莊正定|0||濟(jì)南遙強(qiáng)|0||青島流亭|0||煙臺(tái)萊山|0||南京祿口|0||常州奔牛|0||無(wú)錫碩放|0||南通興東|0||鹽城|0||連云港|0