I can not read this csv file: https://drive.google.com/file/d/1Q3lCw_8Uad_OzHCjvLeYRvamXR74UPbW/view
I've downloaded it and now I am trying to read it using read_csv function.
dataset = pd.read_csv("salary_dataset.csv")getsParserError: Error tokenizing data. C error: EOF inside string starting at row 121535- then I try to do
dataset = pd.read_csv("salary_dataset.csv", quoting=csv.QUOTE_NONE)and I getParserError: Error tokenizing data. C error: Expected 5 fields in line 3, saw 6 - then I try
dataset = pd.read_csv("salary_dataset.csv", quoting=csv.QUOTE_NONE, sep='\t'). now it does not give en error, but I get one mixed column "FullDescription,SalaryNormalized" but it should be two different columns with different values - FullDescription and SalaryNormalized... So it does not parse the comma - but when I try
dataset = pd.read_csv("salary_dataset.csv", quoting=csv.QUOTE_NONE, sep=',')I get errorParserError: Error tokenizing data. C error: Expected 5 fields in line 3, saw 6
meanwhile, everything works fine in Jupyter Lab just with simple pd.read_csv("salary_dataset.csv")... Unfortunately, I need to use Colab because of GPU, please help me out how I can open this csv!