data-analyst

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.

This story was originally published on HackerNoon at: https://hackernoon.com/how-to-use-python-to-retrieve-data-through-tableau-rest-api.
In this blog, we will walk through the process of using Python to extract data from the Tableau Server
Check more stories related to programming at: https://hackernoon.com/c/programming. You can also check exclusive content about #python, #tableau, #rest-api, #business-intelligence, #tableau-server, #how-to-retrieve-views, #creating-a-dataframe, #data-analyst, 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.

Python can be a powerful tool for automating this process using Tableau's REST API. In this blog, we will walk through the process of using Python to extract data from the Tableau Server. The following examples demonstrate how to retrieve information about views, projects, and workbooks.