擅长:python、mysql、java
<p>您可以使用字典,其中每个键都包含一个数据帧作为值:</p>
<pre><code>import os
import pandas as pd
redShiftKeyFolderPath = r'D:\Sunil_Work\temp8\Prod_IMFIFSS2017' # contains 2 csv files i.e Prod_IMFIFSS2017_Indicator.csv & Prod_IMFIFSS2017_Location.csv
def importRedshiftKeys(redShiftKeyFolderPath):
data = {}
for file in os.listdir(redShiftKeyFolderPath):
if file.endswith('.csv'):
csv_file_name = file
i = file.rfind('_'); file = file[i:]; rDfName = 'redShiftKey_' + file.replace('_', '').replace('.csv', '') # taking last part of the file name after _ & excluding .csv
data[rDfName] = redShiftKey = pd.read_csv(os.path.join(redShiftKeyFolderPath, csv_file_name), dtype = object) # importing
return data
importRedshiftKeys(redShiftKeyFolderPath)
</code></pre>
<p>要动态创建变量,您需要检查以下讨论:<a href="https://stackoverflow.com/questions/4010840/generating-variable-names-on-fly-in-python">generating variable names on fly in python</a></p>
<p>但是,字典策略更好,因为您可以处理动态的<code>n</code>数量的csv文件,而且您可以轻松地遍历它们:</p>
^{pr2}$