本文介绍了如何使用pandas库在Python中读取和写入Excel文件。内容包括通过`pd.read_excel()`读取不同工作表，设置header参数处理无列名的情况，通过`index_col`指定索引列，以及利用`skiprows`跳过不需要的行。同时展示了如何使用`df.to_excel()`导出数据到Excel，控制是否包含索引。
refer to:
dframe = pd.read_excel(“file_name.xlsx”)
dframe = pd.read_excel(“file_name.xlsx”, sheetname=”Sheet_name”)
dframe = pd.read_excel(“file_name.xlsx”, sheetname=number)
原文如下:
//
Reading and writingExcel files in Python pandas
In data science, you are very likely to mostly work with CSV files. However, knowing how to import and export Excel files is also very useful.
In this post, a Kaggle dataset on 2016 US Elections was used (https://www.kaggle.com/benhamner/d/benhamner/2016-us-election/primary-results-sample-data/output). This dataset has been converted from a CSV file to an Excel file and two sheets have been added with votes for Hilary Clinton (HilaryClinton) and Donald Trump (DonaldTrump). The first sheet (All) contains the original dataset.
Reading Excel files
dframe = pd.read_excel(“file_name.xlsx”)
Reading Excel files is very similar to reading CSV files. By
最低0.47元/天 解锁文章
扫一扫
2388
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
