CODEWITHSUNDEEP
pythonpandasdataframeexport-to-csv
masonlaw12
masonlaw12

Reputation: 47

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

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")

Upvotes: 0

Views: 3781

Answers (2)

Tom Darby
Tom Darby

Reputation: 181

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)

Upvotes: 1

bb1
bb1

Reputation: 7863

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.

Upvotes: 1

Related Questions