从列表中选择多个数据帧以保存它们

Question

当我编写代码时：

TxtFiles = pd.Series (['Agreements',
                        'Assets',
                        'AssetsIFRS9Amount',
                        ....
                        'Loans',
                        'LoansProducts'
                        ])

# DataFrame_Name.to_pickle ('path/DataFrame_Name.pkl', compression='gzip')
file_pkl = "C://Users/.../060_Python_DataSets/"

for i in TxtFiles:
    print (i)
    str.strip(i).to_pickle (file_pkl+str(i)+'.pkl', compression='gzip')

我收到消息：

  File "<ipython-input-65-73534dab7869>", line 3, in <module>
    str.strip(i).to_pickle (file_pkl+str(i)+'.pkl', compression='gzip')

AttributeError: 'str' object has no attribute 'to_pickle'

系列中的名称是数据帧的名称，我想将它们另存为pickle。有人能帮忙解决这个问题吗

Answer 1

你被恐怖分子抓住了。您应该构建一个字典，将名称映射到对象：

TxtFiles = {'Agreements': Agreements,
            'Assets': Assets,
             ....
            'Loans': Loans,
            'LoansProducts': LoanProducts
            }

然后您将能够执行以下操作：

for i, df in TxtFiles.items():
    print (i)
    df.to_pickle (file_pkl+str(i)+'.pkl', compression='gzip')