合并多个列表
list1 = [1, 2, 3]
list2 = [4, 5, 6]
list3 = [7, 8, 9]list1 = []
for l in [list1,list2,list3]:lists.append(l) ## [[1, 2, 3], [4, 5, 6], [7, 8, 9]]# lists.extend(l) ## [1, 2, 3 , 4, 5, 6 , 7, 8, 9]
print(lists)
合并多个字典
dict1 = {'a': 1, 'b': 2}
dict2 = {'c': 3, 'd': 4}
dict3 = {'e': 5, 'f': 6}dicts = {}
for d in [dict1, dict2, dict3]:dicts.update(d) ### {'a': 1, 'b': 2, 'c': 3, 'd': 4, 'e': 5, 'f': 6}# dicts.append(d)# dicts.extend(d)## 字典不可以使用append和extend
print(dicts)
合并多个df
df1 = pd.DataFrame({'name': ['Alice', 'Bob'], 'age': [25, 30]})
df2 = pd.DataFrame({'name': ['Charlie', 'David'], 'age': [35, 40]})
df3 = pd.DataFrame({'name': ['Eve', 'Frank'], 'age': [45, 50]})dfs = []
for df in [df1, df2, df3]:dfs.append(df)
result_df = pd.concat(dfs,ignore_index=True)
print(dfs) ## 合并之后是一个list
print(result_df) ## 合并之后是一个df
处理文件名提取信息
filenames = ["data_20250305.csv", "data_20250306.csv", "data_20250307.csv"]
dates = []
for filename in filenames:date = filename.replace('data_' , '').replace('.csv' , '')dates.append(date)
print(dates) ### ['20250305', '20250306', '20250307']
处理文件名并合并文件
# 模拟文件夹中的文件内容
file_contents = {"data_20250305.txt": "内容1","data_20250306.txt": "内容2","data_20250307.txt": "内容3"
}contents = []
for filename in file_contents.keys():content = file_contents[filename]contents.append(content)
# result = pd.concat(contents,ignore_index=True)
print(contents) ## ['内容1', '内容2', '内容3']
# print(result)
print(filename) ## data_20250307.txt
print(content) ## 内容3
处理文件并合并df
file_contents = {"data_20250305.xlsx": pd.DataFrame({'name': ['Alice', 'Bob'], 'age': [25, 30]}),"data_20250306.xlsx": pd.DataFrame({'name': ['Charlie', 'David'], 'age': [35, 40]}),"data_20250307.xlsx": pd.DataFrame({'name': ['Eve', 'Frank'], 'age': [45, 50]})
}dfs = []# 使用 for 循环遍历每个文件名,并读取文件内容
for filename in file_contents.keys():df = file_contents[filename]dfs.append(df)combined_df = pd.concat(dfs, ignore_index=True)
print(combined_df)