#๐Ÿ”’ How do I fix this?

10 messages ยท Page 1 of 1 (latest)

waxen jayBOT
#

@woeful isle

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.

timber shore
#

how did you create the dataframe in first place?

woeful isle
#
import pandas as pd
url = "https://en.wikipedia.org/wiki/World_population"
tables = pd.read_html(url)
tables[6]
world_topten = tables[6]```
timber shore
#

it looks like it's using a MultiIndex for the columns, you could try something like df.columns = df.columns.levels[0] or df.columns = df.columns.values[0]

opal sparrow
#

Can also try: tables = pd.read_html(url, header=[0])

woeful isle
woeful isle
woeful isle
#

!close

waxen jayBOT
#
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.