Python Pandas1 Intro and Series

Question 1

What do you have to do before you install the Pandas library?

Answer 1

You have to install NumPy; Pandas is built upon NumPy.

Question 2

What other computing platform is Pandas similar to?

Answer 2

R

Question 3

What new data object types does Pandas introduce?

Answer 3

Series and DataFrames

Question 4

What is the difference between an array and a series?

Answer 4

An array is indexed by integers, but a series can be indexed by labels.

Question 5

How do you create a Series?

Answer 5

you can use the pd.series() function to transform a list, array or dictionary into a Series.

Question 6

What is a DataFrame

Answer 6

A bunch of Series that share an index. Each column of numbers is a named series, except the first pseudo column, which is the index values. pd.DataFrame(randn(5,4), [‘A’,’B’,etc],[‘W’,’X’, etc]

Question 7

How do you extract a column of data?

Answer 7

Like this df[‘W’] or you can pretend df is a SQL table, and do df.W

Question 8

How do you extract a row of data?

Answer 8

Use df.loc[‘A’] to get row A. You can also use its 0-based row index, df.iloc[0]

Question 9

How to get a single value

Answer 9

Get row B, column Y like this: df.loc[‘B’,’Y’]

Question 10

How to get a sub-matrix-type thingy?

Answer 10

df.loc[[‘A’,’B’],[‘W’,’Y’]]