Numpy And Pandas

Question 1

What is a data frame and a series?

Answer 1

I’m pandas, a datagrams corresponds to column and rows (I.e. like a table or spreadsheet).

A series is a 1-d data frame - think of it like just a column (in pandas)

Question 2

What can a data frame be loaded from?

Answer 2

Sql, csv, excel file etc.

Or from a lost, dictionary or list of dictionaries

Question 3

Why is the setindex method important in pandas and what can happen if you don’t set an index?

Answer 3

the loc function does not work if you try to locate a piece of data without having first set (e.g. it’s column name) as an index

Question 4

which indices get used in what order in pandas? I.e. is it [row,column] or [column,row]?

Answer 4

[row,column]