Posts

Showing posts with the label seaborn

Load data from CSV and plot using Seaborn barplot method

Image
For my PDS class! %matplotlib inline import mysql.connector from datetime import date, datetime import sys import pandas as pd import seaborn as sns user,pw, host,db = 'root','it8701','127.0.0.1','anotherdatabase2' cnx = mysql.connector.connect(user=user, password=pw, host=host, database=db) cursor = cnx.cursor() select_stmt = ("SELECT * FROM cea_salespersons") try:   cursor.execute(select_stmt)   df = pd.DataFrame(cursor.fetchall(), columns = ['cea_salesperson_id','salesperson_name', 'registration_no',                                                   'registration_start_date',  'registration_end_date',                                                    'estate_agent_name','estate_agent_license_no...