Informatics Practices
From the DataFrames created in previous question, write code to display only rows 'a' and 'b' for columns 1 and 2 from DataFrames df, df1 and df2.
Answer
import pandas as pd
d = {'one' : pd.Series([1., 2., 3.], index = ['a', 'b', 'c']), 'two' : pd.Series([1., 2., 3., 4.], index = ['a', 'b', 'c', 'd'])}
df = pd.DataFrame(d)
df1 = pd.DataFrame(d, index = ['d', 'b', 'a'])
df2 = pd.DataFrame(d, index = ['d', 'a'], columns = ['two', 'three'])
print(df.loc['a' : 'b', :])
print(df1.loc['b' : 'a', :])
print(df2.loc['d' : 'a', :])Output
one two
a 1.0 1.0
b 2.0 2.0
one two
b 2.0 2.0
a 1.0 1.0
two three
d 4.0 NaN
a 1.0 NaN
Related Questions
From the DataFrames created in previous question, write code to display only row 'a' from DataFrames df, df1, and df2.
From the DataFrames created in previous question, write code to display only rows 0 and 1 from DataFrames df, df1, and df2.
From the DataFrames created in previous question, write code to add an empty column 'x' to all DataFrames.
What will be the output of the following program ?
import pandas as pd dic = {'Name' : ['Sapna', 'Anmol', 'Rishul', 'Sameep'], 'Agg' : [56, 67, 75, 76], 'Age' : [16, 18, 16, 19]} df = pd.DataFrame(dic, columns = ['Name', 'Age']) print(df)(a)
Name Agg Age 101 Sapna 56 16 102 Anmol 67 18 103 Rishul 75 16 104 Sameep 76 19(b)
Name Agg Age 0 Sapna 56 16 1 Anmol 67 18 2 Rishul 75 16 3 Sameep 76 19(c)
Name 0 Sapna 1 Anmol 2 Rishul 3 Sameep(d)
Name Age 0 Sapna 16 1 Anmol 18 2 Rishul 16 3 Sameep 19