Dropna threshold

#dropping columns having more than 50% missing values(1994/2==1000)
df=df.dropna(thresh=1000,axis=1)

Threshold meaning in pandas dropna

>>>df = pd.DataFrame({"name": ['Alfred', 'Batman', 'Catwoman'],
                   "toy": [np.nan, 'Batmobile', 'Bullwhip'],
                   "born": [pd.NaT, pd.Timestamp("1940-04-25"),
                            pd.NaT]}) 
df.dropna(thresh=2)
       name        toy       born
1    Batman  Batmobile 1940-04-25
2  Catwoman   Bullwhip        NaT

Source: pandas.pydata.org

Similar codes

0 vote316 views1 answer
Python Django How To Bulk Update
Python Django
83 votes276 views6 answers
Loop python
Python
0 vote283 views1 answer
Send operator by parameter python
Python
0 vote268 views1 answer
How to make a discord bot in python
Python
0 vote284 views1 answer
How to append panda columns using loop
Python
3 votes309 views2 answers
Interpreter in python
Python
14 votes269 views1 answer
Export a dataframe to excel pandas
Python
7 votes256 views1 answer
Program to find even numbers in python
Python
0 vote295 views1 answer
Django.db.backends.mysql install
Python Django
0 vote236 views1 answer
Read a png file in python
Python