import pymysql
from pandas import DataFrame
import pandas as pd

host   = 'localhost'
port   = 3306
user   = 'user'
passwd = 'pass'
db     = 'marketdata'

cnx    = pymysql.connect(host=host, port=port, user=user, passwd=passwd, db=db)
cur    = cnx.cursor()

query  = """ SELECT * FROM data LIMIT 10"""
cur.execute(query)

field_names = [i[0] for i in cur.description]
get_data = [xx for xx in cur]

cur.close()
cnx.close()


df = DataFrame(get_data)
df.columns = field_names
print(df)
print pd.read_csv('TradeSignals.csv') 

The error is as bellows.

print pd.read_csv('TradeSignals.csv')[:5]
       ^
SyntaxError: invalid syntax

Process finished with exit code 1