一、涉及知识点

1、Excel和pandas创建excel格式的数据源

2、数据格式有很多，常见的如下：CSV文件、数据库表格、文件格式（Excel、PDF、Word等）、HTML文件、JSON文件、文本文件、XML文件

二、遇到的问题及原因

1、pandas库找不到（AttributeError: module 'pandas' has no attribute 'DataFrame'）

原因：1）未安装pandas库

          2）pycharm中解释器配置错误（项目多时需要配置虚拟环境，每个虚拟环境中挂载的库都不一样，pycharm的setting中会有默认的配置，需检查是否错误）

import pandas as pd

df=pd.DataFrame[{'ID':[1,2,3],'Name':['Tim','Victor','N}]

df.to_excel('C:/Temp/output.xlsx')

print('Done!')

pandas is a package

How to use pandas to create an Excel file?

DataFrame(数据帧）

DataFrame is a very important Class in pandas, a DataFrame can be treated as a worksheet in Excel. Take care of the first letter "D" is upper case.

import pandas as pd

df = pd.DataFrame({'ID':[1,2,3],'Name':['Tim','Victor','Nick']})
df = df.set_index('ID')
print(df)
df.to_excel('C:/Temp/output.xlsx')
print('Done!')

'ID' and 'Name' is the name of the column. 

[1,2,3] and ['Tim','Victor','Nick'] is the record under column ID and Name.

Code:

DataFrame.set_index('ID')

is set the column ID as the index. otherwise, the DataFrame will add an additional column as the index.

Code:

DataFram.to_excel('C:/Temp/output.xlsx')

.to_excel is a method of Class DataFrame. that will create an excel file under an absolute address.

Result:

      Name
ID        
1      Tim
2   Victor
3     Nick
Done!

Process finished with exit code 0