Cũng có thể xóa các hàng có giá trị NaN đối với các cột cụ thể bằng cách sử dụng câu lệnh sau.
df.dropna(subset, inplace=True)Với vị trí được đặt thành True và tập hợp con được đặt thành danh sách tên cột để loại bỏ tất cả các hàng có NaN bên dưới các cột đó
ví dụ 1.
Python3
# importing libraries
import pandas as pd
import numpy as np
num= df.dropna(subset, inplace=True)0df.dropna(subset, inplace=True)1df.dropna(subset, inplace=True)2df.dropna(subset, inplace=True)3df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)5df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)7df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)9df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)1df = df.reset_index(drop=True)2
df = df.reset_index(drop=True)3df = df.reset_index(drop=True)4df = df.reset_index(drop=True)2df = df.reset_index(drop=True)6df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)8df = df.reset_index(drop=True)9
# importing libraries0
# importing libraries1= # importing libraries3=# importing libraries5df.dropna(subset, inplace=True)1# importing libraries7
# importing libraries8
# importing libraries1= import1
import2
# importing libraries1
đầu ra
Ghi chú. Chúng ta cũng có thể đặt lại các chỉ số bằng phương thức reset_index()
df = df.reset_index(drop=True)ví dụ 2
Python3
# importing libraries
import pandas as pd
import numpy as np
import9= df.dropna(subset, inplace=True)0_______236_______2df.dropna(subset, inplace=True)2df.dropna(subset, inplace=True)3df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)5_______0_______4df.dropna(subset, inplace=True)7df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)9df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)1df = df.reset_index(drop=True)2
import4df = df.reset_index(drop=True)4df = df.reset_index(drop=True)2df = df.reset_index(drop=True)6df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)8numpy as np0
numpy as np1_______238_______2numpy as np3numpy as np4df.dropna(subset, inplace=True)4numpy as np6df.dropna(subset, inplace=True)4numpy as np8df = df.reset_index(drop=True)2
num0num1df.dropna(subset, inplace=True)4num3df = df.reset_index(drop=True)2num5df = df.reset_index(drop=True)2
num0num8
# importing libraries0
# importing libraries1= =2=234_______5pandas as pd2df.dropna(subset, inplace=True)4numpy as np2# importing libraries7
# importing libraries8
# importing libraries1= import1
df.dropna(subset, inplace=True)03
# importing libraries1= df.dropna(subset, inplace=True)06= df.dropna(subset, inplace=True)08df.dropna(subset, inplace=True)09
df.dropna(subset, inplace=True)10
# importing libraries1
đầu ra
ví dụ 3
Python3
# importing libraries
import pandas as pd
import numpy as np
import9= df.dropna(subset, inplace=True)0df.dropna(subset, inplace=True)20df.dropna(subset, inplace=True)2df.dropna(subset, inplace=True)22df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)24df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)26df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)28df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)30df.dropna(subset, inplace=True)4
df.dropna(subset, inplace=True)32_______0_______33df = df.reset_index(drop=True)2df.dropna(subset, inplace=True)35df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)37numpy as np0
numpy as np1_______0_______40numpy as np3df.dropna(subset, inplace=True)5df.dropna(subset, inplace=True)4numpy as np6df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)46df = df.reset_index(drop=True)2df.dropna(subset, inplace=True)48df.dropna(subset, inplace=True)4
df.dropna(subset, inplace=True)32_______12_______1df = df.reset_index(drop=True)2df.dropna(subset, inplace=True)53df = df.reset_index(drop=True)9
# importing libraries0
# importing libraries1= =2=234_______5df.dropna(subset, inplace=True)20df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)40_______234_______7
# importing libraries8
# importing libraries1= import1
df.dropna(subset, inplace=True)03
# importing libraries1= df.dropna(subset, inplace=True)06= df.dropna(subset, inplace=True)08df.dropna(subset, inplace=True)09
df.dropna(subset, inplace=True)10
# importing libraries1
đầu ra
Ví dụ 4.
Python3
# importing libraries
import pandas as pd
import numpy as np
df.dropna(subset, inplace=True)83= df.dropna(subset, inplace=True)0df.dropna(subset, inplace=True)86_______0_______2df.dropna(subset, inplace=True)88df = df.reset_index(drop=True)2df.dropna(subset, inplace=True)90df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)92df = df.reset_index(drop=True)2
num0df.dropna(subset, inplace=True)95df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)97df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)99df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)01df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)03df = df.reset_index(drop=True)04
numpy as np1_______12_______06numpy as np3df.dropna(subset, inplace=True)5df.dropna(subset, inplace=True)4numpy as np6df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)46df.dropna(subset, inplace=True)4df.dropna(subset, inplace=True)48df = df.reset_index(drop=True)2
df = df.reset_index(drop=True)16_______12_______1df = df.reset_index(drop=True)2df.dropna(subset, inplace=True)53numpy as np0
df = df.reset_index(drop=True)21df = df.reset_index(drop=True)22df.dropna(subset, inplace=True)2df = df.reset_index(drop=True)24df = df.reset_index(drop=True)2df = df.reset_index(drop=True)26df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)28df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)30df.dropna(subset, inplace=True)4
df = df.reset_index(drop=True)16_______12_______33df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)35df = df.reset_index(drop=True)2df = df.reset_index(drop=True)37df = df.reset_index(drop=True)9
# importing libraries0
# importing libraries1= df = df.reset_index(drop=True)42=# importing libraries5df.dropna(subset, inplace=True)86df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)06df.dropna(subset, inplace=True)4
df = df.reset_index(drop=True)49df = df.reset_index(drop=True)22# importing libraries7
# importing libraries8
# importing libraries1= import1
df.dropna(subset, inplace=True)03
# importing libraries1= df.dropna(subset, inplace=True)06= df.dropna(subset, inplace=True)08df.dropna(subset, inplace=True)09
df.dropna(subset, inplace=True)10
# importing libraries1
đầu ra
Ví dụ 5
Python3
df = df.reset_index(drop=True)65
import pandas as pd
import numpy as np
df = df.reset_index(drop=True)70
df = df.reset_index(drop=True)71= df.dropna(subset, inplace=True)0df = df.reset_index(drop=True)74_______0_______2df.dropna(subset, inplace=True)3df = df.reset_index(drop=True)2df = df.reset_index(drop=True)78df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)80df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)82df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)84df = df.reset_index(drop=True)04
df = df.reset_index(drop=True)86df = df.reset_index(drop=True)87numpy as np3df = df.reset_index(drop=True)89df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)91df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)93df = df.reset_index(drop=True)94df = df.reset_index(drop=True)95df = df.reset_index(drop=True)04
df = df.reset_index(drop=True)86df = df.reset_index(drop=True)98numpy as np3_______234_______00df.dropna(subset, inplace=True)4# importing libraries02df = df.reset_index(drop=True)2# importing libraries04df.dropna(subset, inplace=True)4# importing libraries06df = df.reset_index(drop=True)04
df = df.reset_index(drop=True)86# importing libraries09# importing libraries10# importing libraries00df.dropna(subset, inplace=True)4# importing libraries13df.dropna(subset, inplace=True)4# importing libraries15df.dropna(subset, inplace=True)4# importing libraries17# importing libraries18
# importing libraries19
# importing libraries1= # importing libraries22=# importing libraries24
# importing libraries25
# importing libraries26
# importing libraries1= # importing libraries29=# importing libraries31df.dropna(subset, inplace=True)09
# importing libraries33
# importing libraries1= df.dropna(subset, inplace=True)06=df.dropna(subset, inplace=True)08df.dropna(subset, inplace=True)09
# importing libraries1
đầu ra
Trong ví dụ trên, chúng tôi đã sử dụng thresh = 2 bên trong df. dropna() có nghĩa là nó sẽ loại bỏ tất cả các hàng có giá trị Nan/NaT bằng 2 hoặc nhiều hơn 2, các hàng khác sẽ giữ nguyên
Ví dụ 6.
Python3
df = df.reset_index(drop=True)65
import pandas as pd
import numpy as np
df = df.reset_index(drop=True)70
df = df.reset_index(drop=True)71= df.dropna(subset, inplace=True)0df = df.reset_index(drop=True)74_______0_______2df.dropna(subset, inplace=True)3df = df.reset_index(drop=True)2df = df.reset_index(drop=True)78df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)80df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)82df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)84df = df.reset_index(drop=True)04
df = df.reset_index(drop=True)86df = df.reset_index(drop=True)87numpy as np3df = df.reset_index(drop=True)89df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)91df.dropna(subset, inplace=True)4df = df.reset_index(drop=True)93df = df.reset_index(drop=True)94df = df.reset_index(drop=True)95df = df.reset_index(drop=True)04
df = df.reset_index(drop=True)86df = df.reset_index(drop=True)98numpy as np3_______234_______00df.dropna(subset, inplace=True)4# importing libraries02df = df.reset_index(drop=True)2# importing libraries04df.dropna(subset, inplace=True)4# importing libraries06df = df.reset_index(drop=True)04
df = df.reset_index(drop=True)86# importing libraries09# importing libraries10# importing libraries00df.dropna(subset, inplace=True)4# importing libraries13df.dropna(subset, inplace=True)4# importing libraries15df.dropna(subset, inplace=True)4# importing libraries17# importing libraries18
# importing libraries19
# importing libraries1= # importing libraries22=# importing libraries24
import01
import02
# importing libraries1= import05=# importing libraries5df = df.reset_index(drop=True)98# importing libraries7
# importing libraries33
# importing libraries1= df.dropna(subset, inplace=True)06=df.dropna(subset, inplace=True)08df.dropna(subset, inplace=True)09
# importing libraries1
đầu ra
Trong ví dụ trên, chúng tôi sử dụng subset = [‘Oct’] bên trong df. dropna() có nghĩa là nó sẽ xóa tất cả các hàng có giá trị Nan/NaT dưới nhãn 'Tháng 10'