如题,最后生成csv文件的时候需要以对应的DataFrame的名字来给文件分别命名。
请问如何获取当前循环下的DataFrame的名字呢。
ShopCodeList:["店铺1","店铺2"]
for i in ShopCodeList:
i = pd.DataFrame({
'MerchantFulfillmentOrderID': MerchantFulfillmentOrderID,
})
print(dir(i.items))
timeStr = time.strftime('%Y-%m-%d', time.localtime())
i.to_csv(timeStr + i.values +'发货表' + '.txt', sep="\t", index=False, encoding="utf-8")
import pandas as pd
df = pd.DataFrame( data=np.ones([4,4]) )
df.name = 'Ones'
print(df.name)
>>>
Ones
或者
df.attrs['name'] = "My name"
再或者
df = pd.DataFrame()
dfs = {'some_label': df}
可以试试这样创建的时候命名好然后获取
是不是这个意思?
ShopCodeList = ["店铺1","店铺2"]
for i in ShopCodeList:
x = pd.DataFrame({
'MerchantFulfillmentOrderID': MerchantFulfillmentOrderID,})
timeStr = time.strftime('%Y-%m-%d', time.localtime())
x.to_csv(timeStr + i +'发货表' + '.txt', sep="\t", index=False, encoding="utf-8")
是这个意思吗?
dataframe = pd.DataFrame(np.random.rand(6,4),columns=list('ABCD'))
print(dataframe)
# 1. 获取dataframe的列名: dataframe.columns
ColNames = dataframe.columns
print(ColNames,type(ColNames)) # 注意ColNames的类型是object
ColNames_List = dataframe.columns.tolist()
print('------------------------------------------------------')
print(ColNames_List,type(ColNames_List))
你查查,“如何把变量转变为文本”
看看这个
https://blog.csdn.net/m0_59485658/article/details/123410109