🔒 Dataframe th titles not exporting correctly into CSV

[hasty sonnet]

Hi, working on building a personal NFL database and starting with Excel, plan to scale it towards an actual SQL DB -- my dataframes display and load fine from my notebooks cells, however when the CSV is loaded into Google Sheets I get a bunch of aria label junk -- I don't own Excel so I can't confirm if this is exclusive to Sheets or not. Wanted to provide some imgs and the repo link and see what blunder I made, thank you!

https://github.com/griffnsh/2023_24_nfl_data

[copper mauve]

@hasty sonnet

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[idle fog]

print(soup)
boy that's fun to scroll through 😄

[hasty sonnet]

I legit did not mean to leave that it taking it out now lol

It’s gone

[idle fog]

So I think those html tags are coming from the html you're scraping from

ok i found it

this line:
df = pd.DataFrame(columns = qb_categories)

You want to set columns to the array of stripped titles you just made qb_categories_titles

@hasty sonnet

[hasty sonnet]

ily

naming my first born Meltz014

[idle fog]

please do

[copper mauve]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.