我正在嘗試從幾個 .csv 檔案中獲取所有“鏈接”資料,并使用這些鏈接資料創建 .txt 檔案,而不合并到一個檔案中(當前為 result_df.txt)。第一步效果很好!(感謝阿里!)但我想將我的幾個 csv 檔案的名稱(每個名稱都不同)保留到這些 txt 檔案中。
name1.csv --> name1.txt
name2.csv --> name2.txt
name3.csv --> name3.txt
...
請問這里有什么建議嗎?
非常感謝
from os.path import abspath, join
from os import listdir
import pandas as pd
result_df = pd.DataFrame(columns=['link'])
abs_path = abspath(path) # path of your folder
for filename in listdir(abs_path):
df = pd.read_csv(join(abs_path, filename), usecols=['link'])
result_df = pd.concat([result_df, df], ignore_index=True)
result_df.to_csv('result_df.txt', header=None, index=None, sep=' ', mode='w')
uj5u.com熱心網友回復:
那么你為什么要 concat 呢?只需保存到 .txt 檔案更新名稱df.to_csv(filename[:-4] '.txt')
from os.path import abspath, join
from os import listdir
import pandas as pd
result_df = pd.DataFrame(columns=['link'])
abs_path = abspath(path) # path of your folder
for filename in listdir(abs_path):
df = pd.read_csv(join(abs_path, filename), usecols=['link'])
df.to_csv(filename[:-4] '.csv')
轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/436210.html
