Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- df1 = pd.read_csv('c:wamp64wwwstockinfoquotes.csv')
- df2 = df1.sort_values("Symbol")
- df3 = df2.drop_duplicates(subset = "Symbol", keep = 'first')
- kolumns = ['Date', 'Symbol','Current Price','Open', 'High', Low','Volume']
- df4 = pd.DataFrame(df3, columns=kolumns)
- kount = len(df4)
- i = 7
- for j in range(kount):
- for k in range(i):
- if (k == 0):
- stockdate = pd.to_datetime(df4.iat[j,0], format="%Y-%m-%d")
- if (k == 1):
- f = df4.iat[j,1]+ '.csv'
- theFile = "c:\wamp64\www\stockinfo\historical\" + f
- if (k == 2):
- close = df4.iat[j,2].item()
- if (k == 3):
- open = df4.iat[j,3].item()
- if (k == 4):
- high = df4.iat[j,4].item()
- if (k == 5):
- low = df4.iat[j,5].item()
- if (k == 6):
- volume = df4.iat[j,6].item()
- print(theFile)
- myFile = open("c:\wamp64\www\stockinfo\historical\" + f, "at")
- c:wamp64wwwstockinfohistoricalABRCX.csv
- Traceback (most recent call last):
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement