BeautifulSoup main格式读取, 将数据存入CSV之后，无法再次读取
import os
import pandas as pd
data
[<__main__.company_15F at 0x7ae4790>,
<__main__.company_15F at 0x7ae40d0>,
<__main__.company_15F at 0x90076b0>,
<__main__.company_15F at 0x9554fd0>,
<__main__.company_15F at 0x95eef30>,
<__main__.company_15F at 0x9673bd0>,
<__main__.company_15F at 0x96acf70>,
<__main__.company_15F at 0x97a7fd0>,
<__main__.company_15F at 0x97d34b0>,
<__main__.company_15F at 0x966a9f0>,
<__main__.company_15F at 0x9809f30>]
type(data[0])
main.company_15F
Data = pd.DataFrame(data = data)
file = os.getcwd() + '\Data.csv' #保存文件位置，即当前工作路径下的csv文件
Data.to_csv(file, index=False) #数据写入，index=False表示加索引
import pandas as pd
Data = pd.read_csv('Data.csv')
Data = Data['0'].to_list()
Data
['<__main__.company_15F object at 0x07AE4790>',
'<__main__.company_15F object at 0x07AE40D0>',
'<__main__.company_15F object at 0x090076B0>',
'<__main__.company_15F object at 0x09554FD0>',
'<__main__.company_15F object at 0x095EEF30>',
'<__main__.company_15F object at 0x09673BD0>',
'<__main__.company_15F object at 0x096ACF70>',
'<__main__.company_15F object at 0x097A7FD0>',
'<__main__.company_15F object at 0x097D34B0>',
'<__main__.company_15F object at 0x0966A9F0>',
'<__main__.company_15F object at 0x09809F30>']
#Create a dataframe object of it
state_fund_values = pd.DataFrame([[company.company_name,company.stock_holdings["Market Value"].sum(),
] for company in Data])
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
in
1 #Create a dataframe object of it
2 state_fund_values = pd.DataFrame([[company.company_name,company.stock_holdings["Market Value"].sum(),
----> 3 ] for company in Data])
in (.0)
1 #Create a dataframe object of it
2 state_fund_values = pd.DataFrame([[company.company_name,company.stock_holdings["Market Value"].sum(),
----> 3 ] for company in Data])
AttributeError: 'str' object has no attribute 'company_name'
company.company_name
这里company是字符串，不是对象，没有company.company_name属性。