Python Forum
delete rows with empty strings in Series
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
delete rows with empty strings in Series
#1
i have a series (column) from a DataFrame that contains empty strings, ''. i want to delete each element that is empty so this should only contain values with 'Sea' . The data is actually a panda column series but i output it as a List to see the values.

Before: ['Sea', 'Sea', '', '', '', 'Sea', 'Sea', '', '']

Whats the best way to remove these element from the series. I can use this with a list but would rather keep as series.

y = df['ColumnA'].str.strip().tolist()
y = List(filter(None, y) ) After: ['Sea', 'Sea', 'Sea', 'Sea']

how do i do the same from panda series?

i think i figured it out

df[Column 1'].replace('', np.nan).dropna()

is there a better way?
Reply
#2
How about df['ColumnA'][df['ColumnA'] != '']?
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Filter rows by multiple text conditions in another data frame i.e contains strings an Pan 0 2,134 Jun-09-2020, 06:05 AM
Last Post: Pan
  How can I convert time-series data in rows into column srvmig 0 2,036 Apr-11-2020, 05:40 AM
Last Post: srvmig
  How to add a few empty rows into a pandas dataframe python_newbie09 2 16,287 Sep-20-2019, 08:52 AM
Last Post: python_newbie09
  Creating new rows and adding them to empty data frame kapilan15 0 1,650 May-31-2019, 10:19 AM
Last Post: kapilan15

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020