Strip trim all strings of a dataframe

Question

Cleaning the values of a multitype data frame in python pandas  I want to trim the strings  I am currently doing it in two instructions    import pandas as pd  df   pd DataFrame      a     10       c     5     df replace    s        regex True  inplace True   front df replace   s         regex True  inplace True   end  df values   This is quite slow  what could I improve

User · Answer

You can try   df 0    df 0  str strip     or more specifically for all string columns  non numeric columns   list set df columns -set df  get numeric data   columns   df non numeric columns    df non numeric columns  apply lambda x   str x  strip

User · Answer

Money Shot  Here s a compact version of using applymap with a straightforward lambda expression to call strip only when the value is of a string type    df applymap lambda x  x strip   if isinstance x  str  else x    Full Example  A more complete example   import pandas as pd   def trim all columns df               Trim whitespace from ends of each value across all series in dataframe             trim strings   lambda x  x strip   if isinstance x  str  else x     return df applymap trim strings      simple example of trimming whitespace from data elements df   pd DataFrame      a     10       c     5    df   trim all columns df  print df     gt  gt  gt     0   1 0  a  10 1  c   5   Working Example  Here s a working example hosted by trinket  https   trinket io python3 e6ab7fb4ab

User · Answer

If you really want to use regex  then   gt  gt  gt  df replace     s   s          regex True  inplace True   gt  gt  gt  df    0   1 0  a  10 1  c   5   But it should be faster to do it like this    gt  gt  gt  df 0    df 0  str strip

User · Answer

You can use the apply function of the Series object    gt  gt  gt  df   pd DataFrame      a     10       c     5     gt  gt  gt  df 0  0     a     gt  gt  gt  df 0    df 0  apply lambda x  x strip     gt  gt  gt  df 0  0   a       Note the usage of strip and not the regex which is much faster   Another option - use the apply function of the DataFrame object    gt  gt  gt  df   pd DataFrame      a     10       c     5     gt  gt  gt  df apply lambda x  x apply lambda y  y strip   if type y     type     else y   axis 0      0   1 0  a  10 1  c   5

User · Answer

You can use DataFrame select dtypes to select string columns and then apply function str strip   Notice  Values cannot be types like dicts or lists  because their dtypes is object   df obj   df select dtypes   object    print  df obj  0    a   1    c    df df obj columns    df obj apply lambda x  x str strip    print  df      0   1 0  a  10 1  c   5   But if there are only a few columns use str strip   df 0    df 0  str strip

User · Answer

def trim x       if x dtype    object          x   x str split      str 0      return x   df   df apply trim

[python] Strip / trim all strings of a dataframe

Examples related to python

Examples related to regex

Examples related to pandas

Examples related to dataframe

Examples related to trim