I downloaded a CSV file:
urlretrieve(‘https://www.kaggle.com/agirlcoding/all-space-missions-from-1957?select=Space_Corrected.csv’, ‘Space_Data.csv’ )
I verified that the file is comma delimited, so i try to read the file: df = pd.read_csv(‘Space_Data.csv’, delimiter=’,’)
But i get an error because there are commas in some of the fields. so i manually edit the file in jovian.ai site and it becomes tab delimited and i can read it. however, it does not get saved this way from session to session.
what can i do to either download the file as tab delimited, or to save it as a tab delimited.