Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- import urllib.request
- import pymysql.cursors
- connection = pymysql.connect(host='localhost',
- user='',
- password='',
- db='mydb',
- charset='utf8',
- cursorclass=pymysql.cursors.DictCursor)
- try:
- url = 'https://api.iextrading.com/1.0/stock/market/collection/sector?
- collectionName=Health%20Care&format=csv'
- response = urllib.request.urlopen(url)
- csv_data = csv.reader(response)
- for row in csv_data:
- cursor.execute('INSERT INTO Financials (names,
- classes, mark )'
- 'VALUES("%s", "%s", "%s")',
- row)
- finally:
- connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement