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)