Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 18 of 40

Python Pandas — I — Question 20

Back to all questions
20
Question

Question 15(c)

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.

Solution
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
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