Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Writing Data to CSV
#1
Hello,

I am trying to create data frame of Share prices based on data provided by vendor. I am getting an error message "'Series' object has no attribute 'close'" Can you please help me with this issue ?

import pandas as pd
from pandas import DataFrame
import quandl
import datetime as dt

stock_list = pd.read_csv(r"F:\Abhay_New\Abhay\Python\Project\SHARADAR_SF1.csv")
end_date = dt.date.today()
diff_year = dt.timedelta(days=365)
start_date = end_date - diff_year
path = (r"F:\Tradepoint\MyMkt")

for i in range(len(stock_list)):
    data = quandl.get_table('SHARADAR/SEP', date={'gte':start_date, 'lte':end_date}, ticker=stock_list.iloc[i])
    if len(data)>1:
        dict = {'Date':data['date'],'OPEN':data['open'],'HIGH':data['high'],'LOW':data['low'],'CLOSE':data['close'],'VOLUME':data['volume']}
        final_data = pd.DataFrame(dict,columns = ['Date','OPEN','HIGH','LOW','CLOSE','VOLUME'])
        final_data.to_csv(path + '\\' + stock_list.iloc[i] + '.csv', index = False, header = False)
        print(final_data).head()


AttributeError: 'Series' object has no attribute 'close'
Reply


Messages In This Thread
Writing Data to CSV - by abhaydd - Aug-08-2019, 03:32 AM
RE: Writing Data to CSV - by Larz60+ - Aug-08-2019, 08:33 PM
RE: Writing Data to CSV - by DeaD_EyE - Aug-09-2019, 01:08 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Issue in writing sql data into csv for decimal value to scientific notation mg24 8 2,872 Dec-06-2022, 11:09 AM
Last Post: mg24
  Create a function for writing to SQL data to csv mg24 4 1,111 Oct-01-2022, 04:30 AM
Last Post: mg24
  Need Help writing data into Excel format ajitnayak87 8 2,438 Feb-04-2022, 03:00 AM
Last Post: Jeff_t
  Fastest Way of Writing/Reading Data JamesA 1 2,138 Jul-27-2021, 03:52 PM
Last Post: Larz60+
Smile Set 'Time' format cell when writing data to excel and not 'custom' limors 3 6,195 Mar-29-2021, 09:36 PM
Last Post: Larz60+
  writing data to a csv-file apollo 1 2,326 Jul-03-2020, 02:28 PM
Last Post: DeaD_EyE
  python openpyxl writing data Bikram 2 2,412 Oct-17-2019, 03:33 PM
Last Post: Bikram
  Who converts data when writing to a database with an encoding different from utf8? AlekseyPython 1 2,330 Mar-04-2019, 08:26 AM
Last Post: DeaD_EyE
  Help with Code (Writing Data File) caroline_d_124 3 2,817 Jan-06-2019, 09:17 PM
Last Post: caroline_d_124
  Recommend an Excel library for writing data? jonesin1974 1 2,497 Feb-09-2018, 10:28 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020