Styjun

How were the LM astronauts supported during the moon landing and ascent? What were the max G's on them during these phases?

expansion with *.txt in the shell doesn't work if no .txt file exists

Creating Darkness

Why is a dedicated QA team member necessary?

Keyboard shortcut to access contact Quick Search?

What does Kasparov mean by "I was behind in three and even in one after six games"?

Why are there not any MRI machines available in Interstellar?

Is it legal to use cash pulled from a credit card to pay the monthly payment on that credit card?

Print sums of all subsets

Why was Sauron not trying to find the Ring, and instead of preparing for war?

Replacing tongue and groove floorboards: but can't find a match

Magento2: How can I logout customer from controller?

How do I run a game when my PCs have different approaches to combat?

How can I prevent corporations from growing their own workforce?

Do Rabbis get punished in Heaven for wrong interpretations or claims?

Grid/table with lots of buttons

Can two figures have the same area, perimeter, and same number of segments have different shape?

What is the lowest speed of a bogey a jet fighter can intercept/escort?

What does "a good player" mean in the movie Training day?

Area of parallelogram = Area of square. Shear transform

Trapped in an ocean Temple in Minecraft?

How important is a good quality camera for good photography?

Send single HTML mail

Why no ";" after "do" in sh loops?

Unable to append file in python

How can I represent an 'Enum' in Python?How do I use raw_input in Python 3Should I put #! (shebang) in Python scripts, and what form should it take?Best way to convert string to bytes in Python 3?Way to create multiline comments in Python?What is the Python 3 equivalent of “python -m SimpleHTTPServer”Relative imports in Python 3Using Python 3 in virtualenvWhy is “1000000000000000 in range(1000000000000001)” so fast in Python 3?python asyncronous images download (multiple urls)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have this script which is to pull stock prices for the last so many years from yahoo finance.

Once the code is run, i am not able to write again on the file even though it is suppose to check what exists and append.

I get the following error:
FileExistsError: [Errno 17] File exists: 'stocks_dfs'

Please advise!


'''python
import bs4 as bs
import pickle
import requests
import datetime as dt
import pandas as pd
import os
import pandas_datareader.data as web
from time import sleep

def save_sp500_tickers():
 resp = requests.get('https://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
 soup =bs.BeautifulSoup(resp.text,'lxml')
 table=soup.find('table','class':'wikitable sortable')
 tickers=[]
 for row in table.findAll('tr')[1:]:
 ticker= row.findAll('td')[1].text
 tickers.append(ticker)

 with open("sp500ticker.pickle", "wb") as f:
 pickle.dump(tickers,f)

 print (tickers)

 return tickers
#save_sp500_tickers()

def get_data_from_yahoo(reload_sp500=False):
 if reload_sp500:
 tickers=save_sp500_tickers()
 else:
 with open("sp500ticker.pickle","rb") as f:
 tickers=pickle.load(f)
 if not os.path.exists('stock_dfs'):
 os.makedirs('stocks_dfs')

 start = dt.datetime(2016,1,1)
 end = dt.datetime.now()

 for ticker in tickers:
 print(ticker)

 if not os.path.exists('stocks_dfs/.csv'.format(ticker)):
 df = web.DataReader(ticker,'yahoo', start, end)
 df.to_csv('stocks_dfs/.csv'.format(ticker))
 else:
 print('Already have '.format(ticker))

get_data_from_yahoo()

'''

python-3.x yahoo-finance

share|improve this question

edited Mar 26 at 16:33

Inderjeet Singh

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please post stack trace of the error, if any.
  
  – psinaught
  Mar 26 at 16:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try os.mkdir('stocks_dfs') instead of os.makedirs('stocks_dfs')
  
  – maria
  Mar 26 at 16:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @psinaught File "/usr/lib/python3/dist-packages/spyder/utils/site/sitecustomize.py", line 705, in runfile execfile(filename, namespace) File "/usr/lib/python3/dist-packages/spyder/utils/site/sitecustomize.py", line 102, in execfile exec(compile(f.read(), filename, 'exec'), namespace) File "/home/inderjeet/Desktop/untitled1.py", line 55, in <module> get_data_from_yahoo() File "/home/inderjeet/Desktop/untitled1.py", line 41, in get_data_from_yahoo os.makedirs('stocks_dfs') File "/usr/lib/python3.6/os.py", line 220, in makedirs mkdir(name, mode)
  
  – Inderjeet Singh
  Mar 26 at 20:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @maria Thanks for your suggestion: os.mkdir('stocks_dfs') FileExistsError: [Errno 17] File exists: 'stocks_dfs'
  
  – Inderjeet Singh
  Mar 26 at 20:41
  
  

  
  
  
  

add a comment | 

1

I have this script which is to pull stock prices for the last so many years from yahoo finance.

Once the code is run, i am not able to write again on the file even though it is suppose to check what exists and append.

I get the following error:
FileExistsError: [Errno 17] File exists: 'stocks_dfs'

Please advise!


'''python
import bs4 as bs
import pickle
import requests
import datetime as dt
import pandas as pd
import os
import pandas_datareader.data as web
from time import sleep

def save_sp500_tickers():
 resp = requests.get('https://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
 soup =bs.BeautifulSoup(resp.text,'lxml')
 table=soup.find('table','class':'wikitable sortable')
 tickers=[]
 for row in table.findAll('tr')[1:]:
 ticker= row.findAll('td')[1].text
 tickers.append(ticker)

 with open("sp500ticker.pickle", "wb") as f:
 pickle.dump(tickers,f)

 print (tickers)

 return tickers
#save_sp500_tickers()

def get_data_from_yahoo(reload_sp500=False):
 if reload_sp500:
 tickers=save_sp500_tickers()
 else:
 with open("sp500ticker.pickle","rb") as f:
 tickers=pickle.load(f)
 if not os.path.exists('stock_dfs'):
 os.makedirs('stocks_dfs')

 start = dt.datetime(2016,1,1)
 end = dt.datetime.now()

 for ticker in tickers:
 print(ticker)

 if not os.path.exists('stocks_dfs/.csv'.format(ticker)):
 df = web.DataReader(ticker,'yahoo', start, end)
 df.to_csv('stocks_dfs/.csv'.format(ticker))
 else:
 print('Already have '.format(ticker))

get_data_from_yahoo()

'''

python-3.x yahoo-finance

share|improve this question

edited Mar 26 at 16:33

Inderjeet Singh

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Please post stack trace of the error, if any.
  
  – psinaught
  Mar 26 at 16:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Try os.mkdir('stocks_dfs') instead of os.makedirs('stocks_dfs')
  
  – maria
  Mar 26 at 16:37
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @psinaught File "/usr/lib/python3/dist-packages/spyder/utils/site/sitecustomize.py", line 705, in runfile execfile(filename, namespace) File "/usr/lib/python3/dist-packages/spyder/utils/site/sitecustomize.py", line 102, in execfile exec(compile(f.read(), filename, 'exec'), namespace) File "/home/inderjeet/Desktop/untitled1.py", line 55, in <module> get_data_from_yahoo() File "/home/inderjeet/Desktop/untitled1.py", line 41, in get_data_from_yahoo os.makedirs('stocks_dfs') File "/usr/lib/python3.6/os.py", line 220, in makedirs mkdir(name, mode)
  
  – Inderjeet Singh
  Mar 26 at 20:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @maria Thanks for your suggestion: os.mkdir('stocks_dfs') FileExistsError: [Errno 17] File exists: 'stocks_dfs'
  
  – Inderjeet Singh
  Mar 26 at 20:41
  
  

  
  
  
  

add a comment | 

I have this script which is to pull stock prices for the last so many years from yahoo finance.

Once the code is run, i am not able to write again on the file even though it is suppose to check what exists and append.

I get the following error:
FileExistsError: [Errno 17] File exists: 'stocks_dfs'

Please advise!


'''python
import bs4 as bs
import pickle
import requests
import datetime as dt
import pandas as pd
import os
import pandas_datareader.data as web
from time import sleep

def save_sp500_tickers():
 resp = requests.get('https://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
 soup =bs.BeautifulSoup(resp.text,'lxml')
 table=soup.find('table','class':'wikitable sortable')
 tickers=[]
 for row in table.findAll('tr')[1:]:
 ticker= row.findAll('td')[1].text
 tickers.append(ticker)

 with open("sp500ticker.pickle", "wb") as f:
 pickle.dump(tickers,f)

 print (tickers)

 return tickers
#save_sp500_tickers()

def get_data_from_yahoo(reload_sp500=False):
 if reload_sp500:
 tickers=save_sp500_tickers()
 else:
 with open("sp500ticker.pickle","rb") as f:
 tickers=pickle.load(f)
 if not os.path.exists('stock_dfs'):
 os.makedirs('stocks_dfs')

 start = dt.datetime(2016,1,1)
 end = dt.datetime.now()

 for ticker in tickers:
 print(ticker)

 if not os.path.exists('stocks_dfs/.csv'.format(ticker)):
 df = web.DataReader(ticker,'yahoo', start, end)
 df.to_csv('stocks_dfs/.csv'.format(ticker))
 else:
 print('Already have '.format(ticker))

get_data_from_yahoo()

'''

python-3.x yahoo-finance

share|improve this question

edited Mar 26 at 16:33

Inderjeet Singh

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

def save_sp500_tickers():
 resp = requests.get('https://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
 soup =bs.BeautifulSoup(resp.text,'lxml')
 table=soup.find('table','class':'wikitable sortable')
 tickers=[]
 for row in table.findAll('tr')[1:]:
 ticker= row.findAll('td')[1].text
 tickers.append(ticker)

 with open("sp500ticker.pickle", "wb") as f:
 pickle.dump(tickers,f)

 print (tickers)

 return tickers
#save_sp500_tickers()

def get_data_from_yahoo(reload_sp500=False):
 if reload_sp500:
 tickers=save_sp500_tickers()
 else:
 with open("sp500ticker.pickle","rb") as f:
 tickers=pickle.load(f)
 if not os.path.exists('stock_dfs'):
 os.makedirs('stocks_dfs')

 start = dt.datetime(2016,1,1)
 end = dt.datetime.now()

 for ticker in tickers:
 print(ticker)

 if not os.path.exists('stocks_dfs/.csv'.format(ticker)):
 df = web.DataReader(ticker,'yahoo', start, end)
 df.to_csv('stocks_dfs/.csv'.format(ticker))
 else:
 print('Already have '.format(ticker))

get_data_from_yahoo()

share|improve this question

edited Mar 26 at 16:33

Inderjeet Singh

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

share|improve this question

edited Mar 26 at 16:33

Inderjeet Singh

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

asked Mar 26 at 11:21

Inderjeet SinghInderjeet Singh

855 bronze badges

1 Answer
1

active

oldest

votes

0

FileExistsError: [Errno 17] File exists: 'stocks_dfs'

You are complaining that this line fails:

 os.makedirs('stocks_dfs')

To support repeated invocations, you'll want to specify the exist_ok=True flag.

share|improve this answer

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank a lot for your help. It worked!!!
  
  – Inderjeet Singh
  Mar 26 at 20:43
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55355935%2funable-to-append-file-in-python%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

FileExistsError: [Errno 17] File exists: 'stocks_dfs'

You are complaining that this line fails:

 os.makedirs('stocks_dfs')

To support repeated invocations, you'll want to specify the exist_ok=True flag.

share|improve this answer

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank a lot for your help. It worked!!!
  
  – Inderjeet Singh
  Mar 26 at 20:43
  

  
  
  
  

add a comment | 

0

FileExistsError: [Errno 17] File exists: 'stocks_dfs'

You are complaining that this line fails:

 os.makedirs('stocks_dfs')

To support repeated invocations, you'll want to specify the exist_ok=True flag.

share|improve this answer

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank a lot for your help. It worked!!!
  
  – Inderjeet Singh
  Mar 26 at 20:43
  

  
  
  
  

add a comment | 

FileExistsError: [Errno 17] File exists: 'stocks_dfs'

You are complaining that this line fails:

 os.makedirs('stocks_dfs')

To support repeated invocations, you'll want to specify the exist_ok=True flag.

share|improve this answer

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges

 os.makedirs('stocks_dfs')

share|improve this answer

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges

answered Mar 26 at 16:38

J_HJ_H

6,05511 gold badge99 silver badges2424 bronze badges