Using PyCharm to Read Data From a MySQL DataBase Into pandas
Using PyCharm to Read Data From a MySQL DataBase Into pandasimport mysql.connector as sqlimport pandas as pddb_connection = sql.connect(host='hostname', database='db_name', user='username', password='password')db_cursor = db_connection.cursor()db_cursor.execute('SELECT * FROM table_name')table_rows = db_cursor.fetchall()df = pd.DataFrame(table_rows)print the data frameHere is an example output:
0 1 2 3 4 5 6 7 80:ID1lXB+jIS)DN!CXmj>0(P8^]== NaN NaNNoneNoneNoneNoneNoneNone 2lXB+jIS)DN!CXmj>0(P8^]== NaN NaNNoneNoneNoneNoneNoneNone 3lXB+jIS)DN!CXmj>0(P8^]== NaN NaNNoneNoneNoneNoneNoneNone 4lXB+jIS)DN!CXmj>0(P8^]== NaN NaNNoneNoneNoneNoneNoneNone
Use pandas for reading data from your MySQL server because it would be much more efficient:df = pd.read_sql('SELECT * FROM table_name', con=db_connection)
頁:
[1]