python生成excel文件
1.需要cmd下载 pip install pandas 的模板
2.注意文件的路径问题不要出错
3.还有编码格式不要出错 ------encoding = 'gbk'
import pandas as pd
#读取excel文件信息
data = pd.read_csv('C:\\Users\\Administrator\\Desktop\\task.csv',encoding = 'gbk')
# print(data,'\n')#筛选表格中需要的列
data_gender = data[['Actualamount','Merchandise','Time']]
#除去缺失值
data_gender_re = data_gender[data_gender.notnull()]#生成excel文件
data_gender_re.to_csv('C:\\Users\\Administrator\\Desktop\\task11.csv',index=False,encoding = 'gbk')
代码如下:
import pandas as pd
data = pd.read_csv('C:\\Users\\Administrator\\Desktop\\task.csv',encoding = 'gbk')
# print(data,'\n')
data_gender = data[['Actualamount','Merchandise','Time']]
data_gender_re = data_gender[data_gender.notnull()]
data_gender_re.to_csv('C:\\Users\\Administrator\\Desktop\\task11.csv',index=False,encoding = 'gbk')
需要处理的文件如下:
结果如下: