CBSE Class 12 Informatics Practices Question 13 of 21

Python Pandas — II — Question 1

Back to all questions
1
Question

Question 1

Write a program to print a DataFrame one column at a time and print only first three columns.

Solution
import pandas as pd

data = {
    'Name': ['Aliya', 'Hemanth', 'Charlie'],
    'Age': [25, 30, 35],
    'City': ['Bangalore', 'Chennai', 'Mumbai'],
    'Salary': [50000, 60000, 70000]
}

df = pd.DataFrame(data)
first_three_columns = df.iloc[:, :3]

print("Each column:")
for column_name in first_three_columns:
    column_data = first_three_columns[column_name]
    print(column_name)
    print(column_data)
Output
Each column:
Name
0      Aliya
1    Hemanth
2    Charlie
Name: Name, dtype: object
Age
0    25
1    30
2    35
Name: Age, dtype: int64
City
0    Bangalore
1      Chennai
2       Mumbai
Name: City, dtype: object
Answer

import
pandas
as
pd
data
=
{
'Name'
: [
'Aliya'
,
'Hemanth'
,
'Charlie'
],
'Age'
: [
25
,
30
,
35
],
'City'
: [
'Bangalore'
,
'Chennai'
,
'Mumbai'
],
'Salary'
: [
50000
,
60000
,
70000
]
}
df
=
pd
.
DataFrame
(
data
)
first_three_columns
=
df
.
iloc
[:, :
3
]
print
(
"Each column:"
)
for
column_name
in
first_three_columns
:
column_data
=
first_three_columns
[
column_name
]
print
(
column_name
)
print
(
column_data
)
Output
Each column:
Name
0 Aliya
1 Hemanth
2 Charlie
Name: Name, dtype: object
Age
0 25
1 30
2 35
Name: Age, dtype: int64
City
0 Bangalore
1 Chennai
2 Mumbai
Name: City, dtype: object