Hôm nay chúng ta sẽ tìm hiểu cách nhanh chóng tìm xem một hoặc nhiều ô trong các hàng hoặc cột DataFrame của gấu trúc có chứa các giá trị trống hay không [Null, N/A, nan, Không]
Tạo một DataFrame giả
Trước hết, chúng tôi sẽ tạo một Tập dữ liệu rất đơn giản mà bạn có thể sử dụng để làm theo ví dụ này
import pandas as pd
import numpy as np
prog_language = [np.nan, 'Javascript', 'Python', 'Java', 'Python', 'Java']
office = ['Bangkok', 'Osaka', 'Paris', None, pd.NA, 'Paris']
salary = [133.0, 136.0, 127.0, 185.0, 164.0, pd.NA]
data = dict[office=office, prog_language = prog_language, salary = salary]
test_df = pd.DataFrame[data=data]
test_df.head[]
Đây là dữ liệu thử nghiệm của chúng tôi. Lưu ý rằng một số ô trong DataFrame chứa null/NAN/không có giá trị trống
officeprog_languagesalary0BangkokNaN133.01OsakaJavascript136.02ParisPython127.03NoneJava185.04Python164.0Kiểm tra xem một ô DataFrame cụ thể có trống không
Chúng ta có thể sử dụng hàm gấu trúc isna hoặc isnull và bộ truy cập loc hoặc iloc để xác định xem một ô cụ thể có trống không
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
Điều này sẽ trả lại như sau
Your cell is empty.
Theo cách tương tự, sử dụng isnull và bộ bổ sung bộ chỉ mục loc [iloc] để kiểm tra xem ô của chúng ta có chứa giá trị null hay không
if pd.isnull[test_df.iloc[2,1]] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
Kiểm tra xem các ô có trống trong một cột không
Giả sử chúng ta muốn kiểm tra xem một cột có chứa các ô trống không
# define a column to search
my_col = test_df['prog_language']
my_col.isna[].any[]
Điều này trả về Đúng
Tìm nếu các giá trị nan tồn tại trong DataFrame
Để kiểm tra toàn bộ DataFrame, chúng tôi sử dụng một kỹ thuật tương tự
test_df.isna[].any[]
Điều này trả về một Sê-ri boolean, mỗi giá trị liên quan đến từng cột DataFrame của chúng tôi
office True prog_language True salary True dtype: bool
Ghi chú. kỹ thuật này áp dụng cho việc chúng tôi muốn kiểm tra các giá trị NAN trong nhiều cột hoặc hàng
subset = test_df[['office', 'salary']]
# find rows with nulls
subset.isna[].any[axis=1]
# find columns with nulls
subset.isna[].any[]
Tìm kiếm các hàng DataFrame chứa các giá trị nan
Nếu chúng tôi muốn tìm các hàng trong DataFrame chứa bất kỳ giá trị trống nào, chúng tôi có thể sử dụng đoạn mã sau
Gấu trúc coi Không và NaN về cơ bản có thể hoán đổi cho nhau để chỉ ra các giá trị bị thiếu hoặc null. Để tạo thuận lợi cho quy ước này, có một số chức năng hữu ích để phát hiện, xóa và thay thế các giá trị null trong Pandas DataFrame
- isnull[]
- có giá trị[]
- dropna[]
- điền []
- thay thế[]
- nội suy[]
Trong bài viết này, chúng tôi đang sử dụng tệp CSV, để tải xuống tệp CSV đã sử dụng, hãy nhấp vào đây
Kiểm tra các giá trị bị thiếu bằng isnull[] và notnull[]
Để kiểm tra các giá trị còn thiếu trong Pandas DataFrame, chúng tôi sử dụng hàm isnull[] và notnull[]. Cả hai chức năng đều giúp kiểm tra xem một giá trị có phải là NaN hay không. Các chức năng này cũng có thể được sử dụng trong Pandas Series để tìm các giá trị null trong một chuỗi
Kiểm tra các giá trị bị thiếu bằng cách sử dụng isnull[]
Để kiểm tra các giá trị null trong Pandas DataFrame, chúng tôi sử dụng hàm isnull[] hàm này trả về khung dữ liệu của các giá trị Boolean là True cho các giá trị NaN. Mã số 1.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
4import
4# importing pandas as pd
4import
6import
7
# importing pandas as pd
9import
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
00if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
07if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
13if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
14Đầu ra.
con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
15import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
19import
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
2if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18import
4
import
5
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
7if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18import
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
30if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
31Đầu ra. Như thể hiện trong hình ảnh đầu ra, chỉ những hàng có Giới tính = NULL được hiển thị.
Kiểm tra các giá trị bị thiếu bằng cách sử dụng notnull[]
Để kiểm tra các giá trị null trong Pandas Dataframe, chúng tôi sử dụng hàm notnull[] hàm này trả về khung dữ liệu của các giá trị Boolean là Sai đối với các giá trị NaN. Mã số 3.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
4import
4# importing pandas as pd
4import
6import
7
# importing pandas as pd
9import
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
00if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
68if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
# importing pandas as pd
04
# importing pandas as pd
05
Đầu ra.
con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
15import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
19import
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
2if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18import
4
import
5
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18import
9
# importing pandas as pd
21
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
31Đầu ra. Như thể hiện trong hình ảnh đầu ra, chỉ những hàng có Giới tính = KHÔNG NULL được hiển thị.
Điền các giá trị còn thiếu bằng cách sử dụng fillna[], thay thế[] và nội suy[]
Để điền các giá trị null vào bộ dữ liệu, chúng tôi sử dụng hàm fillna[], replace[] và interpolate[], các hàm này thay thế các giá trị NaN bằng một số giá trị của riêng chúng. Tất cả các chức năng này giúp điền vào các giá trị null trong bộ dữ liệu của DataFrame. Hàm nội suy [] về cơ bản được sử dụng để điền các giá trị NA trong khung dữ liệu nhưng nó sử dụng nhiều kỹ thuật nội suy khác nhau để điền các giá trị bị thiếu thay vì mã hóa cứng giá trị. Mã số 1. Điền giá trị null với một giá trị duy nhất
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
4import
4# importing pandas as pd
4import
6import
7
# importing pandas as pd
9import
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
00if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
# importing pandas as pd
59
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
# importing pandas as pd
65
# importing pandas as pd
66# importing pandas as pd
67
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12Đầu ra.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
4import
4# importing pandas as pd
4import
6import
7
# importing pandas as pd
9import
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
00if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
# importing pandas as pd
59
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
import
11
import
12
_______913____16____915____112
Đầu ra.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
4import
4# importing pandas as pd
4import
6import
7
# importing pandas as pd
9import
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
00if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
# importing pandas as pd
59
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
import
59
import
13
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6______962if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12Đầu ra.
con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
15import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
19import
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
2
import
72
import
73
import
74import
75____976import
77import
78
con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
15import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
19import
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
2
import
87
import
88
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
90if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
import
0
Đầu ra.
con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
15import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
19import
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
2
import
72
import
73
import
74import
75____976import
77import
78
Đầu ra.
con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
15import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
19import
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
2if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
017if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
018if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
020if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
022if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
023if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12Đầu ra.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
029if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
032if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
033# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
035# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
037# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
039# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
041# importing pandas as pd
8if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
043if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
044if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
039# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
047# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
049# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
051# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
039# importing pandas as pd
8if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
043if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
056if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
057# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
059# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
039# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
051# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
065# importing pandas as pd
8if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
043if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
068if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
069# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
051# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
039# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
039# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
077if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
078if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
080if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08con trăn
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
082if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
083if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6______1085if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
086if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
088if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12Đầu ra.
Loại bỏ các giá trị bị thiếu bằng cách sử dụng dropna[]
Để loại bỏ các giá trị null khỏi khung dữ liệu, chúng tôi đã sử dụng hàm dropna[] hàm này loại bỏ các Hàng/Cột của bộ dữ liệu có giá trị Null theo các cách khác nhau. Mã số 1. Xoá hàng có ít nhất 1 giá trị null.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
6import
4# importing pandas as pd
4import
6# importing pandas as pd
8
# importing pandas as pd
9import
9# importing pandas as pd
2
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
120# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05# importing pandas as pd
8# importing pandas as pd
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
129____1130if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
131if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
# importing pandas as pd
59
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3# importing pandas as pd
4# importing pandas as pd
5# importing pandas as pd
6# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
6import
4# importing pandas as pd
4import
6# importing pandas as pd
8
# importing pandas as pd
9import
9# importing pandas as pd
2
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
120# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
01# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05# importing pandas as pd
8# importing pandas as pd
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
129____1130if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
131if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
# importing pandas as pd
59
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
190if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
191Đầu ra.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3import
05# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
6import
4# importing pandas as pd
4import
6# importing pandas as pd
8
# importing pandas as pd
9import
9# importing pandas as pd
2
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
120# importing pandas as pd
6if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05# importing pandas as pd
8# importing pandas as pd
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
129____1130if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
131if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
# importing pandas as pd
59
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
18if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3import
05# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
6import
4# importing pandas as pd
4import
6# importing pandas as pd
8
# importing pandas as pd
9import
9# importing pandas as pd
2
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
120# importing pandas as pd
6if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05# importing pandas as pd
8# importing pandas as pd
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
129____1130if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
131if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
08if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
10if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12
import
83
import
84
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 import
86if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
12Đầu ra.
con trăn
________số 8
import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
0import
91
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
1import
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
3import
91
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
5 if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
6 # importing pandas as pd
0# importing pandas as pd
1# importing pandas as pd
2# importing pandas as pd
3import
05# importing pandas as pd
7# importing pandas as pd
8# importing pandas as pd
9import
0import
1import
2# importing pandas as pd
6import
4# importing pandas as pd
4import
6# importing pandas as pd
8
# importing pandas as pd
9import
9# importing pandas as pd
2
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
120# importing pandas as pd
6if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
03# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
05# importing pandas as pd
8# importing pandas as pd
9
if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
129_______82if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
327# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
329# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
331# importing pandas as pd
4if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
131if pd.isna[test_df.loc[2,'office']] is False:
print["Your cell is empty."]
else:
print["Your cell is not empty."]
06