我如何能夠制作一個可以讀取檔案夾中所有 csv 檔案并動態為其分配變數名稱的 python 腳本。資料集的變數名稱將是 csv 檔案的名稱。folder_location例如,在指定的FTX_BTCUSD.csv分配的 csv 檔案將被命名FTX_BTCUSD為變數。Pandas 將用于讀取使用 .csv 檔案的 csv 檔案pd.read_csv()。我如何能夠修改下面的函式以獲得預期的輸出。
import pandas as pd
folder_location = 'C:\\Users\\local\\datasets'
def pandas_datasets():
data= pd.read_csv(**dataset location**, low_memory=False)
return data
檔案夾 csv 檔案

FTX_BTCUSD.csv的內容
unix,date,symbol,open,high,low,close,Volume,Volume USD
1644430740000.0,2022-02-09 18:19:00,BTC/USD,44079.0,44096.0,44076.0,44088.0,0.8561232648339684,37744.7625
1644430680000.0,2022-02-09 18:18:00,BTC/USD,44069.0,44079.0,44055.0,44079.0,3.9830549127702537,175569.0775
1644430620000.0,2022-02-09 18:17:00,BTC/USD,44074.0,44079.0,44055.0,44069.0,7.00427581973723,308671.4311
1644430560000.0,2022-02-09 18:16:00,BTC/USD,44077.0,44078.0,44056.0,44074.0,4.813299484957118,212141.3615
1644430500000.0,2022-02-09 18:15:00,BTC/USD,44033.0,44078.0,44033.0,44077.0,8.620666560791342,379973.12
Binance_BTCUSD.csv的內容
Unix Timestamp,Date,Symbol,Open,High,Low,Close,Volume,Volume USDT,tradecount
1625531700000,2021-07-06 00:35:00,BTC/USDT,34039.99000000,34053.86000000,34023.50000000,34053.86000000,14.84518900,505301.96192877,271
1625531640000,2021-07-06 00:34:00,BTC/USDT,34025.88000000,34049.42000000,34020.11000000,34039.99000000,22.81862800,776568.09766191,404
1625531580000,2021-07-06 00:33:00,BTC/USDT,34050.32000000,34062.77000000,34017.25000000,34025.89000000,16.08606300,547582.96995436,418
1625531520000,2021-07-06 00:32:00,BTC/USDT,34014.66000000,34058.40000000,34001.64000000,34058.39000000,26.11695400,888581.95856325,593
uj5u.com熱心網友回復:
globals()盡管不建議這樣做,但您可以通過創建變數。使用帶有鍵作為檔案名的字典要好得多。
嘗試:
import os
data = dict()
for file in os.listdir(folder_location):
if file.endswith(".csv"):
data[file.replace(".csv","")] = pd.read_csv(os.path.join(folder_location, file))
如果您絕對必須使用檔案名創建動態變數,請改用以下內容:
import os
for file in os.listdir(folder_location):
if file.endswith(".csv"):
globals()[file.replace(".csv","")] = pd.read_csv(os.path.join(folder_location, file))
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/432210.html
下一篇:Tkinter-標簽不更新
