removing newlines from messy strings in pandas dataframe cells?

by

EDIT: the correct answer to this is:

df = df.replace(r'\n',' ', regex=True)

I think you need replace:

df = df.replace('\n','', regex=True)

Or:

df = df.replace('\n',' ', regex=True)

Or:

df = df.replace(r'\\n',' ', regex=True)

Sample:

text=""'hands-on\ndev nologies\nrelevant scripting\nlang
'''
df = pd.DataFrame({'A':[text]})
print (df)
                                                   A
0  hands-on\ndev nologies\nrelevant scripting\nla...

df = df.replace('\n',' ', regex=True)
print (df)
                                                A
0  hands-on dev nologies relevant scripting lang

More Related Contents:

  1. Get last “column” after .str.split() operation on column in pandas DataFrame
  2. Split string every nth character?
  3. Splitting dataframe into multiple dataframes
  4. Split a string by a delimiter in python
  5. Pandas filtering for multiple substrings in series
  6. Create Pandas DataFrame from a string
  7. String concatenation of two pandas columns
  8. Splitting a string into words and punctuation
  9. Pandas split column into multiple columns by comma
  10. How to split strings into text and number?
  11. Convert columns to string in Pandas
  12. Reading a text file and splitting it into single words in python
  13. Product code looks like abcd2343, how to split by letters and numbers?
  14. Left justify string values in a pandas DataFrame
  15. Convert list of strings to dictionary
  16. Filter string data based on its string length
  17. Converting pandas column of comma-separated strings into dummy variables
  18. Is there a way to split a string by every nth separator in Python?
  19. Pandas Dataframe: split column into multiple columns, right-align inconsistent cell entries
  20. How to split a Python string on new line characters [duplicate]
  21. FutureWarning: The default value of regex will change from True to False in a future version
  22. How to remove numbers from string terms in a pandas dataframe
  23. Split a string into 2 in Python
  24. How can I split by 1 or more occurrences of a delimiter in Python?
  25. Split strings in tuples into columns, in Pandas
  26. Filtering pandas dataframe rows by contains str
  27. Copy text between parentheses in pandas DataFrame column into another column
  28. Splitting a math expression string into tokens in Python
  29. Split pandas dataframe in two if it has more than 10 rows
  30. pandas combine two strings ignore nan values

Leave a Comment