Breaking News: Grepper is joining You.com. Read the official announcement!

python snippet to convert html file to .csv file

Sai Naveen answered on June 30, 2022 Popularity 1/10 Helpfulness 1/10

answer python snippet to convert html file to .csv file

python snippet to convert html file to .csv file

Comment

# 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('Geeks.csv')

Popularity 1/10 Helpfulness 1/10 Language html

Source: www.geeksforgeeks.org

Tags: file html python

Link to this answer
Share Copy Link

Contributed on Jun 30 2022

Sai Naveen

0 Answers Avg Quality 2/10

python snippet to convert html file to .csv file

Contents

More Related Answers

python snippet to convert html file to .csv file

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.