Pandas

Question 1

Write the code that is required to run pandas

Answer 1

import pandas as pd

Question 2

Read in a csv file into pandas given

import pandas as pd

Answer 2

pd.read_csv(‘myfile.csv’)

Question 3

Read in a excel file into pandas given

import pandas as pd

Answer 3

pd.read_excel(‘my_file.xlsx’)

Question 4

Read in a json file into pandas given

import pandas as pd

Answer 4

pd.read_json(‘my_file.json’)

Question 5

What is pd in import pandas as pd?

Answer 5

an alias

Question 6

Read in a DataFram file into pandas given

import pandas as pd

Answer 6

pd.DataFrame.from_dict(‘my_file.???)

Question 7

What is the syntax to export DataFrame to other formats?

Answer 7

df.to_csv(‘my_file.csv’)
df.to_excel(‘my_file.xslx’)
df.to_json(‘my_file.json’)
df.to_dict(‘my_file.???’)

Question 8

True or False

like MS Excel, Pandas handles spreedsheet like data called a DataFrame

Answer 8

True

Question 9

.txt stands for?

Answer 9

tab separated file, known as a text file.

Question 10

.csv stands for?

Answer 10

comma separated file, known as a spreadsheet

Question 11

.xlsx stands for?

Answer 11

Microsoft Excel Open XML Spreadsheet

Question 12

.json stands for?

Answer 12

JavaScript Object Notation

Question 13

What is a delimiter in Pandas?

Answer 13

Commas is excel type files are delimiters they separate the data, in Pandas you can detrimine what is going to be used to separate the data being loaded in such as ‘\t’ in .txt files

Question 14

Write the code to read in headers

Answer 14

df.columns( )
print(df.columns)

Question 15

Code to read in a specific column

Answer 15

df. ([‘Name’])
df. Name

Question 16

Code to read in a specific column limited rows

Answer 16

df.Name[0:5]

name column rows 0 - 4

Question 17

Code to read in a number of columns

Answer 17

df[[‘Name’, ‘Attack’, ‘Defense’]]

as a list of col names

Question 18

iloc stands for?

Answer 18

integer location

Question 19

Code to read in a specific DataFrame row

Answer 19

df.iloc[17]

Question 20

Code to read in a multiple DataFrame rows

Answer 20

df.iloc[2:10]

rows 2 - 9

Question 21

What will this return in a Pandas DataFrame?

df.iloc[2,1]

Answer 21

df.iloc[row, col]

Question 22

What does this code achieve?

for index, row in df.iterrows():
print(index, row[‘Name’])

Answer 22

traverses through all the DataFrame rows based on the Name col

Question 23

loc stands for?

Answer 23

is a labeled based location

good for using conditional statements

Question 24

What does this code return in a Pandas DataFrame?

df.loc[df[‘Type 1’] == ‘Fire’]

Answer 24

returns only those records whose Type 1 attribute is labeled Fire

Question 25

What does this code return in a Pandas DataFrame? df.loc[df['Defense'] \< 25]

Answer 25

returns only the records where the Defense is less than 25

Question 26

What does this code provide? df.describe()

Answer 26

high-level numerical stats on the DataFrame

Question 27

This code will return what? df.sort\_values('Name')

Answer 27

sorted DataFrame by Name col in descending order

Question 28

How would you make this sort descending order instead of the default ascending? df.sort\_values('Name')

Answer 28

df.sort\_values('Name', ascending = False)

Question 29

What does this code return in a Pandas DataFrame? df.sort\_values(['Type 1', 'HP'])

Answer 29

both columns are sorted by alpha and numeric ascending order

Question 30

What does this code return in a Pandas DataFrame? df.sort\_values(['Type 1', 'HP'], ascending=[0, 1])

Answer 30

ascending is set to False, True based on the two cols 'Type 1' and 'HP'

Question 31

What is this code doing? df['New Column'] = df['HP'] + df['Attack'] + df['Defense'] + df['Speed']

Answer 31

adding a New Column to the df with concatenated values from the cols HP, Attack, Defense, and Speed.

Question 32

df.head( ) returns what?

Answer 32

First 5 rows of the DataFrame

Question 33

df.tail( ) returns what?

Answer 33

Last 5 rows of a DataFram

Question 34

df.colums( ) returns what?

Answer 34

All the cols in the DataFrame

Question 35

This code is performing what action? df = df.drop(columns=['New Column'])

Answer 35

dropping the New Column and setting it to the df

Question 36

Given this code how many rows will be returned? df.iloc[:,]

Answer 36

all them df.iloc[rows : , cols :]