Scraping Columns with Pandas (Column Entries w/ more than 1 word writes two columns)

[BrandonKastning]

Scraping Columns with Pandas (Column Entries w/ more than 1 word writes two columns)

My code is the following:

import pandas as pd
url = "https://en.wikipedia.org/wiki/List_of_counties_in_Alabama"
tables = pd.read_html(url) 
tables[1]
 
print(tables[1])
 
df = tables[1]
 
df.to_csv('AL_Counties.csv', sep='\t', encoding='utf-8', index=False)

Using Pandas,

Once the file is written; which works great. Any entries in any column; for instance as shown in the following screen shots in Libre Calc is writing the names into multiple columns. This makes my obstacles difficult. How do I remedy this?

Screenshot #1:



Screenshot #2:



Thank you everyone for this forum!