Pandas - Creating Data Frames

Question 1

What are the most important things in Data Frame ?

Answer 1

These are , Index,Colums & Data

Question 2

What is the most important property of Data Frame ?

Answer 2

The most important property of Data Frame is,

every column in a data frame is an Series Object,Series is one dimension data structure.

Question 3

How to know the total index value in Data Fame ?

Answer 3

df.index

Question 4

How to present , only Column Names of Data Frame ?

Answer 4

df.columns

Question 5

How many options to select rows & colums in Data Frame ?

Answer 5

Two Options :

1. Index Integer Position.
2. Labels

Question 6

What is a best thing to filter rows & columns of Data Frame ?

Answer 6

The best way to filter data frame is , column filtering by colums Labels & row filtering by position index?

df[[‘Name’,’Age’]][:’B’]

Question 7

How to present single column by dot notaion ?

Answer 7

df. Name

df. Age

Question 8

In what condition we cant use dot notation for presenting columns ?

Answer 8

When column labels have space between them like,

‘Full Name’ .

Question 9

How to know the object type of pandas dataframe column ?

Answer 9

print(type(df[‘Name’]))

print(type(df.Name))

Question 10

What are the methods in python to access rows & columns of pandas Data Frame ?

Answer 10

loc method for column selection

iloc method for row selection

Question 11

How many ways to acces data frame colums in pandas ?

Answer 11

1 . using square brackets df.[‘Name’]

2. using dot notation df.Name
3. using loc & iloc method df.loc[:,[‘Name’,’Age’]]
   df. iloc[:,:]

Question 12

What is the correct way to use slice with loc method ?

Answer 12

Colon is not allowed in list,use coma to separate.

df. loc[[‘A’,’B’],[‘Name’,’City’]]
df. loc[‘A’:’C’,’Name’]