Pandas

Question 1

loc

Answer 1

loc is primarily label based; when two arguments are used, you use column headers and row indexes to select the data you want. loc can also take an integer as a row or column number.

df.loc[0,’Artist’]: ‘Michael Jackson’

Question 2

iloc

Answer 2

iloc is integer-based. You use column numbers and row numbers to get rows or columns at particular positions in the data frame.

Question 3

iloc slicing

Answer 3

z=df.iloc[0:2,0:3]

Question 4

Import pandas

Answer 4

Pandas have a list of functions including:
read_csv()
Series()
DataFrame
values

import pandas as pd
csv_path = “a.csv”
df = pd.read_csv(csv_path)

df.head() examines the frist 5 rows of data frame.

Question 5

create new dataframe consisting of one column

Answer 5

x=df[[‘Length’]]

Question 6

create multiple columns

Answer 6

y=df[[‘Artist’, ‘Length’, ‘Genre’]]