How do I clean this dataframe. I want to remove "\n" from the table using python without affecting the table

Question

I have this dataframe parsed from a web page using web-scraping. Libraries used are, bs4(BeautifulSoup), pandas, requests and urllib. The table has to be downloaded in csv for data visualisation in tableau afterwards. So without affecting any of the rows and columns, I want to remove "\n" from the dataframe. Any help will be appreciatenter image description hereed.

Answer 1

You could do something like this:

rank_details["Pos"] = Pos.text.strip('\n')

Answer 2

I think your question is answered within this question.

More precisely,

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

should do it for you. Please note that after this, you may also need to strip the strings from leading and trailing whitespaces, and also to convert some of the columns (seemingly Pos should be an integer), with the astype method.