Coursera Capstone Project – Data Analysis and Interpretation

Bydatapandasadmin March 31, 2016April 25, 2016

What is it

This week, I started the Data Analysis and Interpretation Capstone
by Wesleyan University on Coursera. This is the final of 5 course specialisation. The capstone project is expected to take 4 weeks. With each week tackling and doing a major component of the Project work.

What is the objective

The objective of this capstone project is to allow the candidate to continue to apply and refine the data analytic techniques learned from the previous courses in the Specialization to address an important issue in society. Hence it helps us to hone our skills further to solving real world problems and scenarios.

Data given

In this project, we are given the chance to work with industry partners like the Connection (www.theconnectioninc.org) and DRIVENDATA (www.drivendata.org). We are also given access to work on leading world organisations like the World Bank. I chose to work with data on World Bank due to the impact World Bank is making globally.

I am already loving the course and capstone project as I am beginning to appreciate and recognise the link between the previous courses we learned and how to link them to finding solutions to real world and every day issues.

Watch out for my final report upon completion of the capstone project and my final thoughts and feelings about it.

Update: My final report is ready and you can check it out here:

Prediction of Adjusted Net National Income Per Capita of Countries

You can also download my full report as PDF straight into your inbox here:

Download It Now

Coursera | Data Science

Generating a Correlation Coefficient – Data Analysis and Intrepretation
Bydatapandasadmin January 16, 2016October 23, 2016

Chosen Dataset I will be working with Data from the Gapminder dataset. This happens to be the same dataset I worked with under the Data Management and Visualization course assignments. As elaborated and discussed in under the Data Management and Visualization course assignments, I have chosen to focus on the country, Ghana. Hence I will be particularly interested in…

Read More Generating a Correlation Coefficient – Data Analysis and Intrepretation
Azure Machine Learning | Data Science | Machine Learning | Python

Deploy Productionalise Azure Machine Learning Algorithm Using Python
ByBernard Adabankah July 24, 2018

This is a script to consume Azure Machine Learning Model which you build using Azure ML Studio. So basically this is a Request-Response Service (RRS) according to Microsoft. This was a Boosted Decision Tree Algorithm build with Census Adult Data which is available as one of the Sample DataSet in Azure ML. You can adapt the…

Read More Deploy Productionalise Azure Machine Learning Algorithm Using Python
Python

Read_csv Is Not Returning A Dataframe Python Pandas
Bydatapandasadmin August 7, 2016

I was working with a CSV file on a project and after reading the CSV into the Program with the pandas.read_csv function the returned data type seemed not be a Dataframe for some reason code was as follows: sample = pd.read_csv(‘sample.csv’) When i tried to run some functions on the supposed ‘returned dataframe object -sample’ I…

Read More Read_csv Is Not Returning A Dataframe Python Pandas

Python

Python Pandas Pivot Table Index location Percentage calculation on Two columns

Bydatapandasadmin October 5, 2016October 23, 2016

pivot table for year on year This is a quick example of how to use pivot_table, to calculate year on year percentage sales . In [162]:

import sqlalchemy

import pyodbc

import numpy as np

from pandas import DataFrame

from bokeh.plotting import figure, output_file, show

import pandas as pd

In [163]:

df = DataFrame

## connect to SqlServer Database and get information.

try:

import urllib

params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=Antrak;Trusted_Connection=yes;")

engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params)

resoverall = engine.execute("SELECT * FROM FlightBookingsMain")

df = df(resoverall.fetchall())

df.columns = resoverall.keys()

except (RuntimeError, TypeError, NameError):

print('Error in Conneccting')

print(RuntimeError, TypeError, NameError)

finally:

print("connected")

connected

In [164]:

1 2	#lets check the head df.head()

Out[164]: First Name Last Name Sex Phone Fax Email Address Booking Date Departure Date Arrival Date Address1 … Number of Passengers…

Python | Uncategorized

Save Python Pivot Table in Excel Sheets ExcelWriter

Bydatapandasadmin October 5, 2016October 23, 2016

Untitled This is a quick script on how to save Python pivot_table in an excel file. Credit to pbpython In [1]:

import sqlalchemy

import pyodbc

from pandas import DataFrame

import pandas as pd

In [2]:

df = DataFrame

## connect to SqlServer Database and get information.

try:

import urllib

params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=Antrak;Trusted_Connection=yes;")

engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params)

resoverall = engine.execute("SELECT * FROM FlightBookingsMain")

df = df(resoverall.fetchall())

df.columns = resoverall.keys()

except (RuntimeError, TypeError, NameError):

print('Error in Conneccting')

print(RuntimeError, TypeError, NameError)

finally:

print("connected")

connected

In [8]:

df.head()

Out[8]: First Name Last Name Sex Phone Fax Email Address Booking Date Departure Date Arrival Date Address1 … Number of Passengers Total Cost Currency Numeric Code…

Python

Python Bokeh plotting Data Exploration Visualization And Pivot Tables Analysis

Bydatapandasadmin October 4, 2016October 23, 2016

This is a quick walk through Bokeh data exploration and visualization and also python pivot_tables (credit to pbpython on the pivot_tables).Visualization Dashboard In [49]:

import sqlalchemy

import pyodbc

from pandas import DataFrame

from bokeh.plotting import figure, output_file, show

import pandas as pd

In [50]:

df = DataFrame

## connect to SqlServer Database and get information.

try:

import urllib

params = urllib.quote_plus("DRIVER={SQL Server Native Client 11.0};SERVER=.\MSSQLSERVER_ENT;DATABASE=Antrak;Trusted_Connection=yes;")

engine = sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect=%s"' % params)

resoverall = engine.execute("SELECT top 10 * FROM FlightBookingsMain")

df = df(resoverall.fetchall())

df.columns = resoverall.keys()

except (RuntimeError, TypeError, NameError):

print('Error in Conneccting')

print(RuntimeError, TypeError, NameError)

finally:

print("connected")

connected

In [51]:

1 2	#lets look at the head of the dataframe df.head()

Out[51]: First Name Last Name Sex Phone Fax Email Address Booking Date Departure Date Arrival Date Address1 … Number of Passengers Total Cost Currency…

Coursera Capstone Project – Data Analysis and Interpretation

Generating a Correlation Coefficient – Data Analysis and Intrepretation

Deploy Productionalise Azure Machine Learning Algorithm Using Python

Read_csv Is Not Returning A Dataframe Python Pandas

Python Pandas Pivot Table Index location Percentage calculation on Two columns

Save Python Pivot Table in Excel Sheets ExcelWriter

Python Bokeh plotting Data Exploration Visualization And Pivot Tables Analysis

Leave a Reply Cancel reply

DataPandas LTS

EXPLORE DataPandas

ImportAnt link

GET IN TOUCH

© 2026 DataPandas

Similar Posts

Leave a Reply Cancel reply

DataPandas LTS

EXPLORE DataPandas

ImportAnt link

GET IN TOUCH

© 2026 DataPandas