Пример #1
0
def workingSpace(cnx):
    sql = ("select * from newyorkexchange.ibm_historicalquotes_newyork")
    df = connectMysqlDB.query(cnx).pandasQuery(sql)
    #print(df.head(100))
    #df['AdjClose'].hist()
    #p.show()
    return df
Пример #2
0
def collectData():
    host='149.171.37.73'
    userName='******'
    password='******'
    database='sydneyexchange'
    cnx = mysql.connector.connect();
    try:
        #get cnx used for connecting DB
        cnx = connectMysqlDB.cnxStock(host=host,userName=userName,password=password,database=database).connect()
        
        # collecting IBM historical data
        sql = ('select Date , AdjClose, (Volume * AdjClose / Close) AdjVolume from newyorkexchange.aapl_historicalquotes_newyork where Date > \'2010-1-1\'')
        df = connectMysqlDB.query(cnx).pandasQuery(sql)
    finally:
        cnx.close()
    return df
Пример #3
0
# import mysql.connector
import connectMysqlDB
# from mysql.connector import cursor
# import pandas as pd
# import pandas.io.sql as psql
import pylab as p

host='149.171.37.73'
userName='******'
password='******'
database='sydneyexchange'

cnx = connectMysqlDB.cnxStock(host=host,userName=userName,password=password,database=database).connect()
sql = ("SELECT * from aac_historicalquotes_sydney")
df = connectMysqlDB.query(cnx).pandasQuery(sql)
print(df.head(100))
df['Open'].hist()
p.show()

train_data = df.head(100)
test_data = df.head();

cnx.close()

#cnx = mysql.connector.connect(user='******', password='******', host='149.171.37.73', database='sydneyexchange')


# cursor = cnx.cursor()
# query = ("SELECT * from aac_historicalquotes_sydney")
# df = psql.read_sql(query, cnx)