I have a URL that downloads a csv file, to open it I am using the following code:
df = pd.read_csv(url)
most URLs I am using only contain a single table and they open fine, but some have the following format which causes an error:
The csv file is divided into two tables by a set of two empty rows.
The code currently returns the following error:
ParserError: Error tokenizing data. C error: Expected 4 fields in line 9, saw 5
I am trying to read in both tables and then combine them into one table such as the following: