data-analysis

This story was originally published on HackerNoon at: https://hackernoon.com/how-to-connect-to-oracle-mysql-and-postgresql-databases-using-python.
To connect to a database and query data, you need to begin by installing Pandas and Sqlalchemy.
Check more stories related to programming at: https://hackernoon.com/c/programming. You can also check exclusive content about #python, #database, #oracle, #mysql, #postgresql, #data-engineering, #data-analyst, #data-analysis, and more.

This story was written by: @luca1iu. Learn more about this writer by checking @luca1iu's about page, and for more stories, please visit hackernoon.com.

To connect to a database and query data, you need to begin by installing Pandas and Sqlalchemy.

This story was originally published on HackerNoon at: https://hackernoon.com/saving-dataframes-into-oracle-database-with-python.
Here are two common errors that you'll want to watch out for when using the to_sql method to save a data frame into an Oracle database.
Check more stories related to programming at: https://hackernoon.com/c/programming. You can also check exclusive content about #python, #database, #pandas, #data-analysis, #data-analyst, #data-engineering, #sql, #oracle, and more.

This story was written by: @luca1iu. Learn more about this writer by checking @luca1iu's about page, and for more stories, please visit hackernoon.com.