- 博客(3)
- 资源 (4)
- 收藏
- 关注
转载 python 把多个excel、csv写成同一excel多个sheet
import pandas as pd# 创建一个输出文件writer = pd.ExcelWriter('E:/test/he.xlsx')data = pd.read_table('E:/test/chuncker.csv',sep=',',encoding='GBK')data.to_excel(writer,'data',index=False)base = pd.read_
2017-09-12 13:52:34 4107
原创 python读写excel、csv
import pandas as pdfrom pandas import Series,DataFrameproject_name='017'df1 = pd.read_excel('E:/%s.xls'%project_name,encoding = "GBK") #encoding = "GBK",中文编码格式#文件过大,逐块迭代chuncker=pd.read_cs
2017-09-08 15:25:05 524
原创 pandas去重、缺失
from numpy import nanfrom pandas import DataFrameflag=[]k=21flag.append(k)print(flag[0])print(len(flag))a=nanif a is nan: a='KK'else: a=a+','+'KK'print(a)b='bd'if b=='bd': prin
2017-09-08 14:37:03 410
数据分析_企业的贤内助.pdf
2017-10-17
Python Cookbook(第3版)中文版.pdf
2017-10-17
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人