omitting row with empty field in pandas

Question

I have a pandas dataframe

seq   value
ACCCT   1
ACTGS   2
        3
ACCTC   4

I want to omit the rows which have an empty field in the seq column. I tired the following but it did not work

   new_frame = pd.DataFrame(columns = design_frame.columns)
   for idx,row in design_frame.iterrows():
          seq = design_frame.ix[idx,'seq']

           if not seq == '':
                   new_row = design_frame.ix[idx,:]
                   new_frame = new_frame.append(new_row,ignore_index = True)


   design_frame = new_frame

joris · Accepted Answer · 2015-02-12 20:23:34Z

4

You can use dropna for that if the you want to remove the empty rows:

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

However, I think you do not have NaN values, but empty strings (''). In that case you eg do df[df['seq']!=''], or first convert the empty strings to NaN values (df[df['seq']==''] = np.nan)

In any case, you should try to avoid iterating over the dataframe for such cases.

answered Feb 12, 2015 at 20:23

joris

140k37 gold badges258 silver badges207 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

omitting row with empty field in pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related