Home > Net >  sql database a panda
sql database a panda

Time:03-21

hello someone can help me I must create a program in Python that connects to my database, read the database records and create a pivot table with Pandas with that data

CodePudding user response:

You might be looking for pandas.read_sql

You can use con parameter to pass your database connection string.

CodePudding user response:

Here's a link to connect SQL to Python. Depending on the database you use, library will vary. Search for your particular database to python connection.

https://www.geeksforgeeks.org/how-to-connect-python-with-sql-database/

This will give you a 5 min crash course with Pandas and how to use pivot tables.

https://medium.com/bhavaniravi/python-pandas-tutorial-92018da85a33#:~:text= Get Started With Pandas In 5 mins,DataFrame and understood its structure, let’s... More

  • Related