How To Export Table From Python

In this tutorial, we will learn how to export a table from Python to various formats such as CSV, Excel, and HTML.

Exporting data from Python is a common task for data analysis and reporting purposes. It allows you to share your data with others, store it in external tools, or even display it on webpages.

For this tutorial, we will be using the widely popular pandas library to create and export tables from Python.

Step 1: Install pandas and openpyxl

First, we need to install the pandas library if you haven’t already. You can install pandas using pip by running the following command:

pip install pandas

In addition, to export data to Excel, we will also need the openpyxl library. You can install it using the following command:

1	<code>pip install openpyxl</code>

Step 2: Import the libraries

Now that we have installed the required libraries, let’s import them in our Python script.

1	import pandas as pd

Step 3: Create a sample table in Python

For this tutorial, let’s create a simple table using Pandas DataFrame. You can replace this with your own data if you wish.

data = {'Name': ['Alice', 'Bob', 'Caroline', 'David'],

'Age': [25, 28, 22, 30],

'City': ['New York', 'San Francisco', 'Los Angeles', 'Chicago']}

df = pd.DataFrame(data)

Our table will look like this:

      Name  Age          City
0    Alice   25      New York
1      Bob   28 San Francisco
2 Caroline   22   Los Angeles
3    David   30       Chicago

Step 4: Export the table to CSV

To export the table to a CSV file, you can use the to_csv() method provided by Pandas DataFrame.

1	df.to_csv('my_table.csv', index=False)

This code will create a file named “my_table.csv” in your current directory with the following content:

Name,Age,City
Alice,25,New York
Bob,28,San Francisco
Caroline,22,Los Angeles
David,30,Chicago

Step 5: Export the table to Excel

To export the table to an Excel file, you can use the to_excel() method provided by Pandas DataFrame.

1	df.to_excel('my_table.xlsx', index=False, engine='openpyxl')

This code will create a file named “my_table.xlsx” in your current directory with our table data.

Step 6: Export the table to HTML

To export the table to an HTML format, you can use the to_html() method provided by Pandas DataFrame.

html_data = df.to_html(index=False)

with open("my_table.html", "w") as file:

file.write(html_data)

This code will create a file named “my_table.html” in your current directory with our table data rendered as an HTML table.

Full Python code

import pandas as pd

# Create DataFrame

data = {'Name': ['Alice', 'Bob', 'Caroline', 'David'],

'Age': [25, 28, 22, 30],

'City': ['New York', 'San Francisco', 'Los Angeles', 'Chicago']}

df = pd.DataFrame(data)

# Export to CSV

df.to_csv('my_table.csv', index=False)

# Export to Excel

df.to_excel('my_table.xlsx', index=False, engine='openpyxl')

# Export to HTML