如何将这些扭曲的数据以表格格式放入csv文件中

Question

请在下面找到我用来将扭曲数据以表格格式放入CSV文件的代码：

import requests
from bs4 import BeautifulSoup
import csv

f = open('moneyControl-bonus','w' , newline = '')
writer = csv.writer(f)

f2 = open('moneyControl-dividend','w' , newline = '')
writer2 = csv.writer(f2)

url = 'https://www.moneycontrol.com/stocks/marketinfo/upcoming_actions/home.html'

headers = {'user-agent':'Mozilla/5.0'}
response = requests.get(url,headers)

soup = BeautifulSoup(response.content,'lxml')
div = soup.find_all('div',class_='tbldata36 PT10')[0]

for table in div.find_all('table'):
    for row in table.find_all('tr'):
         writer.writerow[row]

    
div2 = soup.find_all('div',class_='tbldata36 PT20')[0]

for table2 in soup.find_all('table'):
     for row2 in table2.find_all('tr'):
            writer2.writerow[row2]

Answer 1

你试过使用pandas吗？这是用于编写csv格式的默认库

# pip install pandas
import pandas as pd

您可以通过传递列表列表或口述方式写入CSV文件

df = pd.DataFrame({'col1':[1,2,3,4],'col2':['a','b','c','d']})
df = pd.DataFrame([[1,2,3,4],['a','b','c','d']],columns=['col1','col2'])

df.to_csv(path_and_name_of_file)

您可以使用许多不同的格式，例如Excel、表格、文本、json等

请看一下official DataFrame Documentation