/Python/Remove nan particular column pandas

Remove nan particular column pandas

How to delete na values in a dataframe

# if you want to delete rows containing NA values
df.dropna(inplace=True)

How to remove rows with nan in pandas

df.dropna(subset=[columns],inplace=True)

Remove nan particular column pandas

 df=df.dropna(subset=['columnname])

Pandas drop row with nan

import pandas as pd

df = pd.DataFrame({'values_1': ['700','ABC','500','XYZ','1200'],
                   'values_2': ['DDD','150','350','400','5000'] 
                   })

df = df.apply (pd.to_numeric, errors='coerce')
df = df.dropna()
df = df.reset_index(drop=True)

print (df)

Source: datatofish.com

Similar codes

1 vote118 views1 answer
Django createmany
Python
0 vote128 views1 answer
Python login to O365
Python
0 vote126 views1 answer
Is power of python recursion
Python
0 vote91 views1 answer
Django import "" could not be resolved
Python
34 votes134 views2 answers
Train-test split code in pandas
Python
2 votes134 views2 answers
Fillna string
Python
0 vote163 views1 answer
Get number of nodes networkx
Python
0 vote130 views1 answer
Python find HCF
Python
21 votes123 views4 answers
Convert radians to degrees python
Python
0 vote135 views1 answer
Python json indented
Python