wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Practice: Data exploration in Pandas

Total questions: 28

Worksheet time: 31mins

Name
Class
Date
1.

Put in correct order

​ (a)   ​ (b)   ​ (c)   ​ (d)  

Choose from the below words
import
pandas
as
pd
2.

Put in correct order

​ (a)   ​ (b)   ​ (c)   ​ ​

Choose from the below words
houses =
pd.read_csv
("houses.csv")
(houses.csv)
3.

How can you display first 5 rows of the data?

a)

.head(5)

b)

.first(5)

c)

.head()

d)

.show(5)

4.

How can you see information of the data?

a)

.info()

b)

.(info)

c)

.information()

d)

.data()

5.

Which one will show the smallest value?

a)

.max()

b)

.smallest()

c)

.min()

d)

.mean()

6.

Which one will show the average value?

a)

.max()

b)

.average()

c)

.min()

d)

.mean()

7.

" "

(a)  

8.

()

(a)  

9.

[ ]

(a)  

10.

=

(a)  

11.

Which one will show percentage %?

a)

.value_counts(normalize=True)

b)

.value_counts()

c)

.value_counts(normalize=true)

d)

.value_counts(%)

12.

See the most expensive house:

houses["price"]​ (a)  

Choose from the below words
.min()
.mean()
.valuea_counts()
.max()
13.

See the cheapest house:

houses["price"]​ ​ (a)  

Choose from the below words
.max()
.mean()
.valuea_counts()
.min()
14.

See the oldest house:

houses["year_built"]​ ​ (a)  

Choose from the below words
.max()
.mean()
.value_counts()
.min()
15.

See the newest house:

houses["year_built"]​ ​ (a)  

Choose from the below words
.mean()
.value_counts()
.max()
.min()
16.

See the average size of house:

houses["area_m2"]​ ​ ​ (a)  

Choose from the below words
.max()
.mean()
.value_counts()
.min()
17.

See the number of houses with an elevator:

houses["area_m2"]​ ​ ​ (a)  

Choose from the below words
.max()
.value_counts()
.min()
.mean()
18.

See the percentage of houses near the metro:

houses["area_m2"]​ ​ ​ (a)  

Choose from the below words
.max()
.value_counts(normalize=True)
.min()
.mean()
.value_counts()
19.

Identify parts of the table

20.

How many columns do we have?

(a)  

21.

How many rows (houses) do we have?

(a)  

22.

I want to know the size of our houses. Which column should I check?

(a)  

23.

I want to know where the houses are. Which column should I check?

(a)  

24.

I want to know if an apartment is in a tall building. Which column should I check?

(a)  

25.

What kind of data is 数值型数据

(a)  

26.

What kind of data is 分类数据

(a)  

27.

What kind of data is 连续型数据

(a)  

28.

What kind of data is 离散型数据

(a)