Homework 3 - Tryout pandas and numpy

Copy this notebook. Rename it as: YOURNAME-Homework-panda-numpy-Sept-2017

with your name replacing yourname and replaced with the date you submit or to the last part.

Do the homeworks problems below.

Upload your completed jupyter notebook to your github site and send me the url via the elearning site as your homework submission. Please note that you need to do your own 3.4, and 3.5 if you share data and analysis from others then you cannot get more than a 3.

Homework 3.1

3.1.a

Load the data from: http://opendata.dc.gov/datasets that I have include in this github
into a dataframe. ( The file has been is available in directory ./data/ccp_current_csv.csv )


In [ ]:

3.1.a what is its shape and what does that mean?


In [ ]:

Homework 3.2

What are the number of rows in each 'QUADRANT' ?


In [ ]:

Homework 3.3 - Array math demonstration

For two arrarys

a= [1,2,3,4] type=float

b= [5,6,7,8] type=float

Peform the following array operations using numpy
( show both operational use of numpy and functional (example addition operation => + vs addition function => numbpy.add() )

3.3.1 addition a+b


In [ ]:

3.3.2 subtraction a-b


In [ ]:

3.3.3 multiplication a*b


In [ ]:

3.3.4 divsion a/b


In [ ]:

3.3.5 modulo a%b


In [ ]:

3.3.6 power a^b


In [ ]:

Homework 3.4

Find your own data and load it into a dataframe


In [ ]:

Homework 3.5

Provide an interesting analysis of the data columns ( frequency or averages )


In [ ]:


In [ ]:


In [ ]:


In [ ]:


In [ ]: