数据处理中需要处理多个csv文件,分别操作太麻烦了,于是用蠢笨的方法合成了一个csv,求助各位专业人士有没有化简方法

import pandas as pd

f1 = pd.read_csv('k (1).csv')
f2 = pd.read_csv('k (2).csv')
f3 = pd.read_csv('k (3).csv')
f4 = pd.read_csv('k (4).csv')
f5 = pd.read_csv('k (5).csv')
f6 = pd.read_csv('k (6).csv')
f7 = pd.read_csv('k (7).csv')
f8 = pd.read_csv('k (8).csv')
f9 = pd.read_csv('k (9).csv')
f10 = pd.read_csv('k (10).csv')
f11 = pd.read_csv('k (11).csv')
f12 = pd.read_csv('k (12).csv')
f13 = pd.read_csv('k (13).csv')
f14 = pd.read_csv('k (14).csv')
f15 = pd.read_csv('k (15).csv')
f16 = pd.read_csv('k (16).csv')
f17 = pd.read_csv('k (17).csv')
f18 = pd.read_csv('k (18).csv')
f19 = pd.read_csv('k (19).csv')
f20 = pd.read_csv('k (20).csv')
f21 = pd.read_csv('k (21).csv')
f22 = pd.read_csv('k (22).csv')
f23 = pd.read_csv('k (23).csv')
f24 = pd.read_csv('k (24).csv')
f25 = pd.read_csv('k (25).csv')
f26 = pd.read_csv('k (26).csv')
f27 = pd.read_csv('k (27).csv')
f28 = pd.read_csv('k (28).csv')
f29 = pd.read_csv('k (29).csv')
f30 = pd.read_csv('k (30).csv')
f31 = pd.read_csv('k (31).csv')
f32 = pd.read_csv('k (32).csv')
f33 = pd.read_csv('k (33).csv')
f34 = pd.read_csv('k (34).csv')
f35 = pd.read_csv('k (35).csv')
f36 = pd.read_csv('k (36).csv')
f37 = pd.read_csv('k (37).csv')
f38 = pd.read_csv('k (38).csv')
f39 = pd.read_csv('k (39).csv')
f40 = pd.read_csv('k (40).csv')
f41 = pd.read_csv('k (41).csv')
f42 = pd.read_csv('k (42).csv')
f43 = pd.read_csv('k (43).csv')
f44 = pd.read_csv('k (44).csv')
f45 = pd.read_csv('k (45).csv')
f46 = pd.read_csv('k (46).csv')
f47 = pd.read_csv('k (47).csv')
f48 = pd.read_csv('k (48).csv')
f49 = pd.read_csv('k (49).csv')
f50 = pd.read_csv('k (50).csv')
f51 = pd.read_csv('k (51).csv')
f52 = pd.read_csv('k (52).csv')
f53 = pd.read_csv('k (53).csv')
f54 = pd.read_csv('k (54).csv')
f55 = pd.read_csv('k (55).csv')
f56 = pd.read_csv('k (56).csv')
f57 = pd.read_csv('k (57).csv')
f = [f1, f2, f3, f4, f5, f6, f7, f8, f9, f10, f11, f12, f13, f14, f15, f16, f17, f18, f19, f20, f21, f22, f23, f24, f25, f26, f27, f28, f29, f30, f31, f32, f33, f34, f35, f36, f37, f38, f39, f40, f41, f42, f43, f44, f45, f46, f47, f48, f49, f50, f51, f52, f53, f54, f55, f56, f57]
outfile = pd.concat(f, axis=1)
outfile.to_csv("all"+".csv", index=0, sep=',')

一共57个文件,用循环嵌套生成 “f” 会在最后生成csv文件是出现错误, 提示 list 文件无法使用outfile 输出,既然简洁方法不行,有需要抓紧时间就只能用穷举法了,将每个文件用有规律的变量名称一一读取,之后组合。但考虑到之后可能会用到更多csv文件,每次都穷举也不容易,再次请教各位专业人士有什么方法化简

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值