Python 中pandas.read_excel详细介绍

2024-02-18 09:33:03 260

Python中pandas.read_excel详细介绍

#coding:utf-8
importpandasaspd
importnumpyasnp

filefullpath=r"/home/geeklee/temp/all_gov_file/pol_gov_mon/downloads/1.xls"
#filefullpath=r"/home/geeklee/temp/all_gov_file/pol_gov_mon/downloads/26368f3a-ea03-46b9-8033-73615ed07816.xls"
df=pd.read_excel(filefullpath,skiprows=[0])
#df=pd.read_excel(filefullpath,sheetname=[0,2],skiprows=[0])
#sheetname指定为读取几个sheet，sheet数目从0开始
#如果sheetname=[0,2]，那代表读取第0页和第2页的sheet
#skiprows=[0]代表读取跳过的行数第0行，不写代表不跳过标题
#df=pd.read_excel(filefullpath,sheetname=None,skiprows=[0])

printdf
printtype(df)
#若果有多页，type(df)就为
#如果就一页，type(df)就为
#{0:dataframe,1:dataframe,2:dataframe}

pandas.read_excel(io,sheetname=0,header=0,skiprows=None,skip_footer=0,
index_col=None,names=None,parse_cols=None,parse_dates=False,date_parser=None,
na_values=None,thousands=None,convert_float=True,has_index_names=None,converters=None,
engine=None,squeeze=False,**kwds)

ReadanExceltableintoapandasDataFrame

参数解析：

io:string,pathobject(pathlib.Pathorpy._path.local.LocalPath),

file-likeobject,pandasExcelFile,orxlrdworkbook.ThestringcouldbeaURL.ValidURLschemesincludehttp,ftp,s3,andfile.ForfileURLs,ahostisexpected.Forinstance,alocalfilecouldbefile://localhost/path/to/workbook.xlsx

sheetname:string,int,mixedlistofstrings/ints,orNone,default0

Stringsareusedforsheetnames,Integersareusedinzero-indexedsheetpositions.

Listsofstrings/integersareusedtorequestmultiplesheets.

SpecifyNonetogetallsheets.

str|int->DataFrameisreturned.list|None->DictofDataFramesisreturned,withkeysrepresentingsheets.

AvailableCases

Defaultsto0->1stsheetasaDataFrame
1->2ndsheetasaDataFrame
“Sheet1”->1stsheetasaDataFrame
[0,1,”Sheet5”]->1st,2nd&5thsheetasadictionaryofDataFrames
None->AllsheetsasadictionaryofDataFrames

header:int,listofints,default0

Row(0-indexed)touseforthecolumnlabelsoftheparsedDataFrame.IfalistofintegersispassedthoserowpositionswillbecombinedintoaMultiIndex

skiprows:list-like

Rowstoskipatthebeginning(0-indexed)

skip_footer:int,default0

Rowsattheendtoskip(0-indexed)

index_col:int,listofints,defaultNone

Column(0-indexed)touseastherowlabelsoftheDataFrame.PassNoneifthereisnosuchcolumn.Ifalistispassed,thosecolumnswillbecombinedintoaMultiIndex

names:array-like,defaultNone

Listofcolumnnamestouse.Iffilecontainsnoheaderrow,thenyoushouldexplicitlypassheader=None

converters:dict,defaultNone

Dictoffunctionsforconvertingvaluesincertaincolumns.Keyscaneitherbeintegersorcolumnlabels,valuesarefunctionsthattakeoneinputargument,theExcelcellcontent,andreturnthetransformedcontent.

parse_cols:intorlist,defaultNone

IfNonethenparseallcolumns,
Ifintthenindicateslastcolumntobeparsed
Iflistofintsthenindicateslistofcolumnnumberstobeparsed
Ifstringthenindicatescommaseparatedlistofcolumnnamesandcolumnranges(e.g.“A:E”or“A,C,E:F”)

squeeze:boolean,defaultFalse

IftheparseddataonlycontainsonecolumnthenreturnaSeries

na_values:list-like,defaultNone

ListofadditionalstringstorecognizeasNA/NaN

thousands:str,defaultNone

Thousandsseparatorforparsingstringcolumnstonumeric.NotethatthisparameterisonlynecessaryforcolumnsstoredasTEXTinExcel,anynumericcolumnswillautomaticallybeparsed,regardlessofdisplayformat.

keep_default_na:bool,defaultTrue

Ifna_valuesarespecifiedandkeep_default_naisFalsethedefaultNaNvaluesareoverridden,otherwisethey'reappendedto

verbose:boolean,defaultFalse

IndicatenumberofNAvaluesplacedinnon-numericcolumns

engine:string,defaultNone

Ifioisnotabufferorpath,thismustbesettoidentifyio.AcceptablevaluesareNoneorxlrd

convert_float:boolean,defaultTrue

convertintegralfloatstoint(i.e.,1.0–>1).IfFalse,allnumericdatawillbereadinasfloats:Excelstoresallnumbersasfloatsinternally

has_index_names:boolean,defaultNone

DEPRECATED:forversion0.17+indexnameswillbeautomaticallyinferredbasedonindex_col.ToreadExceloutputfrom0.16.2andpriorthathadsavedindexnames,useTrue.

return返回的结果

parsed:DataFrameorDictofDataFrames

DataFramefromthepassedinExcelfile.SeenotesinsheetnameargumentformoreinformationonwhenaDictofDataframesisreturned.

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！

Python 中pandas.read_excel详细介绍

热门推荐

随机推荐