将表格数据转换成json格式

使用panda，您可以像下面这样转换表。还可以看看熊猫。to_json，您可以将json转换成许多不同的方向来满足您的需求。

import requests
import csv
from bs4 import BeautifulSoup
import pandas as pd

def getContent(link, filename, whichtable=0):
    result1 = requests.get(link)
    src1 = result1.content
    soup = BeautifulSoup(src1,'lxml')
    table = soup.find_all('table')[whichtable]
    with open(filename,'w',newline='') as f:
        writer = csv.writer(f)
        for tr in table('tr'):
            #print(tr)
            row = [t.get_text(strip=True)for t in tr(['td','th'])]
            writer.writerow(row)

getContent('https://en.wikipedia.org/wiki/List_of_highest-grossing_films', 'what.csv', whichtable=0)

df = pd.read_csv('what.csv')
df.to_json()