DataFrames - PANDAS DataFrames

Question 1

A Pandas DataFrame is a 2 dimensional data structure, like a 2 dimensional array, or a table with rows and columns.

Answer 1

Pandas DataFrames

Question 2

Locate Row - DataFrame is like a table with rows and columns.

Answer 2

Locate Row

Question 3

Locate Row - Pandas use the loc attribute to return one or more specified row(s)

Answer 3

Locate Row

Question 4

DataFrame - When using [], the result is a Pandas DataFrame.

Answer 4

DataFrame

Question 5

Named Indexes - With the index argument, you can name your own indexes.

Answer 5

Named Indexes

Question 6

Locate Named Indexes - Use the named index in the loc attribute to return the specified row(s).

Answer 6

Locate Named Indexes

Question 7

Load Files Into a DataFrame -
If your data sets are stored in a file, Pandas can load them into a DataFrame.

Answer 7

Load Files Into a DataFrame

Question 8

Exercise - True or False. A DataFrame is like a table with rows and columns.

Answer 8

True

Question 9

Exercise - Insert the correct Pandas method to create a DataFrame.

Answer 9

pd.DataFrame(data)

Question 10

Exercise - Insert the correct syntax to return the first row of a DataFrame.

Answer 10

df.loc[0]

Question 11

Exercise - Insert the correct syntax for loading CSV files into a DataFrame.

Answer 11

df.read_csv(data)

Question 12

Exercise - Consider the following Code:
data = {
‘calories’: [420, 380, 390],
‘duration’: [50, 40, 45]
}
df = pd.DataFrame(data)
print(df.loc[0]) What type will the printed result have?

Answer 12

A Pandas Series

Question 13

Exercise - Insert the correct syntax for loading JSON files into a DataFrame.

Answer 13

df.read_json
(data)

Question 14

Exercise - Insert the correct syntax for loading a Python dictionary called “data” into a DataFrame.

Answer 14

pd.DataFrame(data)

Question 15

Exercise - Insert the correct syntax for returning the headers and the first 10 rows of a DataFrame.

Answer 15

df.head(10)

Question 16

Exercise - When using the head() method, how many rows are returned if you do not specify the number?

Answer 16

The headers and 5 rows