我在一個檔案夾中有一系列 txt 檔案，我想將這些檔案移動到資料框中
但我只能通過保存 csv 檔案來做到這一點，如何直接使用資料框而不必保存到 csv 檔案？
按照我下面的代碼
import os
import csv
import pandas as pd
main_folder = ('F:\PROJETOS\LOTE45\ARQUIVOS\RISK\RISK_CUSTOM_FUND_N1'
def get_filename(path):
filenames = []
files = [i.path for i in os.scandir(path) if i.is_file()]
for filename in files:
filename = os.path.basename(filename)
filenames.append(filename)
return filenames
files = get_filename(main_folder)
with open('some.csv', 'w', encoding = 'utf8', newline = '') as csv_file:
for _file in files:
file_name = _file
with open(main_folder '\\' _file,'r') as f:
text = f.read()
writer = csv.writer(csv_file)
writer.writerow([file_name, text])
df = pd.read_csv('some.csv')
uj5u.com熱心網友回復：
你可以嘗試運行這樣的東西：
df = pd.DataFrame()
for _file in files:
df = df.append(pd.read_csv(_file), ignore_index=True, sort=False)
uj5u.com熱心網友回復：
您可以嘗試使用字典并將其轉換為資料框。
# your code to obtain the files
data = {"filename":[], "text":[]}
for file in files:
with open(file, "r") as file_object:
content = file_object.read()
data["filename"].append(file)
data["text"].append(content)
dataframe = pd.DataFrame(data)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/383041.html
上一篇：過濾列，指定區分大小寫