pandas对多个excel合并操作

最新推荐文章于 2024-08-21 14:05:40 发布

weixin_44491431

最新推荐文章于 2024-08-21 14:05:40 发布

阅读量330

点赞数

分类专栏： pandas 文章标签： excel 自然语言处理

本文链接：https://blog.csdn.net/weixin_44491431/article/details/106662066

版权

pandas 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

给别人写了个简单的逻辑，做个记录

# coding=utf-8
# @Time : 2020/3/21 15:51
# @Author : lining
import pandas as pd
import numpy as np
from time import strftime,localtime
print('开始计算：'+strftime("%Y-%m-%d %H:%M:%S", localtime()))
#获取从EXCEL第4行开始往下所有值，并且对第三列、第12列强制类型转换为字符串
df1=pd.DataFrame(pd.read_excel("01订单文件.xlsx",sheet_name=0,usecols=[1,2,3,5,6,11,35,49,107],
                              skiprows=[0,1,2],converters = {'Unnamed: 2': str,'Unnamed: 11': str}))
#将制定表头重新命名
df1.rename(columns = {"Unnamed: 1": "订单状态","Unnamed: 2": "订单号", "Unnamed: 3":"运营商", "Unnamed: 5":"地市",
                      "Unnamed: 6":"区县","Unnamed: 11":"站址编码", "Unnamed: 49":"产品配置"},  inplace=True)
#将空置替换为0
df1['[维护费原始值] '].fillna(0, inplace=True)
#合并值，生成列
df1['sheet名']='铁塔类订单确认表'
#####取第二个sheet
df2=pd.DataFrame(pd.read_excel("01订单文件.xlsx",sheet_name=0,usecols=[1,2,3,5,6,11,35,49,107],
                              skiprows=[0,1,2],converters = {'Unnamed: 2': str,'Unnamed: 11': str}))
#将制定表头重新命名
df2.rename(columns = {"Unnamed: 1": "订单状态","Unnamed: 2": "订单号", "Unnamed: 3":"运营商", "Unnamed: 5":"地市",
                      "Unnamed: 6":"区县","Unnamed: 11":"站址编码", "Unnamed: 49":"产品配置"},  inplace=True)
#将空置替换为0
df2['[维护费原始值] '].fillna(0, inplace=True)
#合并值，生成列
df2['sheet名']='铁塔类订单确认表1'

#合并表格 axis=0表示上下合并，1表示左右合并，ignore_index=True表示忽略原来的索引

res = pd.concat([df1,df2],axis=0,ignore_index=True)


writer = pd.ExcelWriter('0610.xlsx')
res.to_excel(writer,index=False)
writer.save()
print('计算结束：'+strftime("%Y-%m-%d %H:%M:%S", localtime())+"请查看0610文件")