using pandas to find not null cells inside csv file and print them into a new one

Question

I have a csv file with 3 columns inside as in the picture

I want to get the English and Spanish but ignore the fields that are null in Spanish so my expected output is

any Ideas how to do it ?

I tried to read the file using pandas but it prints all the files i want it to ignore the nulls and just print the English and Spanish — programming freak, May 11 '20 at 07:28
So you want to drop the rows where Spanish is null? Have a look here https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.dropna.html — k88, May 11 '20 at 07:28
@jezrael but it prints the French as well is there a solution for that ? can you post it as an answer please so I can accept it — programming freak, May 11 '20 at 07:36

jezrael · Accepted Answer · 2020-05-11T07:47:50.027

1

Use DataFrame.dropna with subset for list for test missing values and then remove French column by DataFrame.drop:

df1 = df.dropna(subset=['English','Spanish']).drop(['French'],axis=1).reset_index(drop=True)

Or if only 3 columns first remove French and then test all columns:

df1 = df.drop(['French'], axis=1).dropna().reset_index(drop=True)

edited May 11 '20 at 07:47

answered May 11 '20 at 07:37

jezrael

df1 = tdata.dropna(subset=['English','Spanish']).dropna('French', axis=1) TypeError: dropna() got multiple values for argument 'axis' – programming freak May 11 '20 at 07:39
what does that mean ? – programming freak May 11 '20 at 07:39
@programmingfreak - oops, my typo, it is `drop` – jezrael May 11 '20 at 07:40
thank you so much man I will use .reset_index(drop=True) to reset the indexs as well – programming freak May 11 '20 at 07:41
@Jezeal what if I have one more column to drop like dutch ? when I place it next to french it tells TypeError: drop() got multiple values for argument 'axis' is there a solution around it ? – programming freak May 11 '20 at 07:47
1

`['French', 'Dutch']` – jezrael May 11 '20 at 07:48

1 Answers1