Excel sheets parsing

Question

Hey! I have one thought, which library is a best for parsing excel sheets and including it in dB in python?

Answer 1

You can use Pandas to import excel sheets and sqlite3 to load it to SQL

Answer 2

Вячеслав Светлаков, you are right. The SQL module now uses sqlalchemy to support different database flavors. You can pass sqlalchemy engine for a PostgreSQL database. For example:

from sqlalchemy import create_engine

engine = create_engine('postgresql://scott:tiger@localhost:5432/mydatabase')

df.to_sql('table_name', engine)

Answer 3

Pandas is good choice, but Postgresql for example, can't get dataframe from to_sql method. And now i seek new solve for it!) You help me, i hope)

Answer 4

First, select the column of cells that contains the raw data, then open the Data menu and choose Text To Columns. When you do, Excel launches the Convert Text To Columns Wizard. Make sure the Delimited radio button is selected, and click Next.

For more check out the link https://www.cetpainfotech.com/technology/advance-excel-training