Python 中pandas.read_excel详细介绍 #coding:utf-8import pandas as pdimport numpy as npfilefullpath = 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])print dfprint type(df)#若果有多页,type(df)就为type 'dict'#如果就一页,type(df)就为class 'pandas.core.frame.DataFrame'#{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, t……
python去重pandas_解决Pandas同元素多列去重问题
最新推荐文章于 2024-02-27 15:05:39 发布