export html table to csv python
# Importing the required modules
import os
import sys
import pandas as pd
from bs4 import BeautifulSoup
path = 'html.html'
# empty list
data = []
# for getting the header from
# the HTML file
list_header = []
soup = BeautifulSoup(open(path),'html.parser')
header = soup.find_all("table")[0].find("tr")
for items in header:
try:
list_header.append(items.get_text())
except:
continue
# for getting the data
HTML_data = soup.find_all("table")[0].find_all("tr")[1:]
for element in HTML_data:
sub_data = []
for sub_element in element:
try:
sub_data.append(sub_element.get_text())
except:
continue
data.append(sub_data)
# Storing the data into Pandas
# DataFrame
dataFrame = pd.DataFrame(data = data, columns = list_header)
# Converting Pandas DataFrame
# into CSV file
dataFrame.to_csv('MyTable.csv') Are there any code examples left?
New code examples in category Python
Relative searches
export data table as csv in python
Export a table to a CSV file python
convert html table to csv file python
export python csv into table html
html table to csv converter python
python save table as csv
save csv as table python
csv to html table python
convert csv to html table python
Convert CSV file to HTML table using Python
extract csv from html in python
html to csv python
convert htm to csv python
export google spreadsheet to csv using python script
python extract html table to csv
export list to csv python
import csv file to html table
how to convert html file to csv in python
html table to csv python
extract html table to csv python
python html table to csv
python export to csv
export html table to csv python
