Python AttributeError: 'list' object has no attribute 'to_csv'

Question

I'm currently encountering an error with my code, and I have no idea why. I originally thought it was because I couldn't save a csv file with hyphens in it, but that turns out not to be the case. Does anyone have any suggestions to what might be causing the problem. My code is below:

import pandas as pd
import requests

query_set = ["points-per-game"]

for query in query_set:
    url = 'https://www.teamrankings.com/ncaa-basketball/stat/' + str(query)
    html = requests.get(url).content
    df_list = pd.read_html(html)
    print(df_list)

    df_list.to_csv(str(query) + "stat.csv", encoding="utf-8")

the error is pretty clear - you are attempting to call .to_csv to a python list (which would obviously fail) — Asish M.
– Asish M., Commented Feb 15, 2021 at 4:40
as stated below you need to call the dataframe element from the list. Also, no need for html = requests.get(url).content as pandas .read_html() has the capablities to request the html. simply can do df_list = pd.read_html(url) — chitown88
– chitown88, Commented Feb 15, 2021 at 10:17

Tom Darby · Accepted Answer · 2021-02-15 04:43:29Z

1

the read_html() method returns a list of dataframes, not a single dataframe:

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_html.html

You'll want to loop through your df_list and run to_csv on each entry, like so:

import pandas as pd import requests

query_set = ["points-per-game"]

for query in query_set:
    url = 'https://www.teamrankings.com/ncaa-basketball/stat/' + str(query)
    html = requests.get(url).content
    df_list = pd.read_html(html)
    print(df_list)

    for current_df in df_list:
      current_df.to_csv(str(query) + "stat.csv", encoding="utf-8")
      print(current_df)

answered Feb 15, 2021 at 4:43

Tom Darby

1816 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bb1 · Accepted Answer · 2021-02-15 04:42:38Z

1

The function pd.read_html returns a list of DataFrames found in the HTML source. Use df_list[0] to get the DataFrame which is the first element of this list.

answered Feb 15, 2021 at 4:42

bb1

7,9232 gold badges11 silver badges26 bronze badges

Collectives™ on Stack Overflow

Python AttributeError: 'list' object has no attribute 'to_csv'

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related