Data Analysis

Data AnalysisPostgresql

Connect to Heroku postgres with pgAdmin

pgAdmin is the most popular Open Source administration and development platform for PostgreSQL. How to set up pgAdmin 1.Install the software here. Create Heroku server connection 2. Right click on server, select Create and Server 3. Add in name for your connection. 4. Navigate to Connection tab. Fill in the credentials from Heroku as documented…

Data Analysis
0

Install Pandas for data analysis (Windows)

1) First set up Python (Windows 10) Install Cygwin to run Linux terminal on window. I personally prefer to use Linux/Unix Command-line interface. Download and install latest Python Add the Python installation path to Windows’ PATH ENVIRONMENT VARIABLE Run export PATH=”$PATH:/cygdrive/c/Python27″  or Open the Control Panel In the Control Panel, open System and Security and…