I want to read a csv file that contains data extracted from the airbnb site. In csv the data is arranged using the function (text to column). I managed to read this data using the following lines of code, but the result appears in the form of compressed columns (that is, all the data in the second column is also in the first column), the data being mixed. I want the results to appear correctly in the form of a table, with lines and columns. How can I solve this?
I also put an image with the way it is displayed now.
import pandas as pd
tot = pd.read_csv(“tot.csv”)
tot.head()