AttributeError: type object 'DataFrame' has no attribute 'pd'

Question

import pandas as pd
import os
import time
from datetime import datetime

path = "C:/Users/Aben/Downloads/intraQuarter"

def Key_Stats(gather="Total Debt/Equity (mrq)"):
    statspath = path+'/_KeyStats'
    stock_list = [x[0] for x in os.walk(statspath)]
    df = pd.DataFrame(columns = ['Date','Unix','Ticker','DE Ratio'])

    sp500_df = pd.DataFrame.pd.read_csv("YAHOO-INDEX_CSPC.csv")

    for each_dir in stock_list[1:]:
        each_file = os.listdir(each_dir)
        ticker = each_dir.split("\\")[1]
        if len(each_file) > 0:
            for file in each_file:
                date_stamp = datetime.strptime(file, '%Y%m%d%H%M%S.html')
                unix_time = time.mktime(date_stamp.timetuple())
                full_file_path = each_dir+'/'+file
                source = open(full_file_path,'r').read()
                try:
                    value = float(source.split(gather+':</td><td class="yfnc_tabledata1">')[1].split('</td>')[0])

                    try:
                        sp500_date = datetime.fromtimestamp(unix_time).strftime('%Y-%m-%d')
                        row = sp500_df[sp500_df["Date"] == sp500_date]
                        sp500_value = float(row["Adj Close"])
                    except:
                        sp500_date = datetime.fromtimestamp(unix_time-259200).strftime('%Y-%m-%d')
                        row = sp500_df[sp500_df["Date"] == sp500_date]
                        sp500_value = float(row["Adj Close"])


                    stock_price = float(source.split('</small><big><b>')[1].split('</b></big>')[0])
                    print("stock_price:",stock_price,"ticker:",ticker)                     

                    df = df.append({'Date':date_stamp,'Unix':unix_time,'Ticker':ticker,'DE Ratio':value,}, ignore_index = True)
                except Exception as e:
                    pass

    save = gather.replace(' ','').replace('(','').replace(')','').replace('/','')+('.csv')
    print(save)
    df.to_csv(save)

Key_Stats()

when running this code in python 3.8.3, I get this error message:

Traceback (most recent call last):
  File "C:\Users\Aben\Downloads\pythonstuff\stockbot.py", line 49, in <module>
    Key_Stats()
  File "C:\Users\Aben\Downloads\pythonstuff\stockbot.py", line 14, in Key_Stats
    sp500_df = DataFrame.pd.read_csv("YAHOO-INDEX_CSPC.csv")
AttributeError: type object 'DataFrame' has no attribute 'pd'

anyone know why? I replaced from_csv with pd.read_csv, but now I have another error. The file I'm using is actually a txt file, but I renamed it with the .csv extension at the end. I'm using this tutorial btw

NYC Coder · Accepted Answer · 2020-05-30 15:37:50Z

1

Replace this line:

sp500_df = pd.DataFrame.pd.read_csv("YAHOO-INDEX_CSPC.csv")

with

sp500_df = pd.read_csv("YAHOO-INDEX_CSPC.csv")

answered May 30, 2020 at 15:37

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

AttributeError: type object 'DataFrame' has no attribute 'pd'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related