bar ( bar_l, mid_rel, bottom = pre_rel, label = 'Other', alpha = 0.9, color = '#3C5F5A', width = bar_width, edgecolor = 'white' ) # Set the ticks to be first names ax. bar ( bar_l, pre_rel, label = 'Drug Listings', alpha = 0.9, color = '#019600', width = bar_width, edgecolor = 'white' ) ax.
subplots ( 1, figsize = ( 10, 5 )) bar_width = 1 # positions of the left bar-boundaries bar_l = ))] # positions of the x-axis ticks (center of the bars as bar labels) tick_pos = # Create the total totals =, comparison_df )] # Create the percentage pre_rel =, totals )] mid_rel =, totals )] # Create a bar chart in position bar_1 ax. iloc print ( comparison_df ) # Create a figure with a single subplot f, ax = plt. pandas_query ( ''' SELECT count(*) as 'drug_listings' FROM tblProduct WHERE subCategory_id in (SELECT subCategory_id from tblSubCategory where subCategory_name IN ('2C', '5-MeO', 'Barbiturates', 'Benzos', 'Buprenorphine', 'Cannabis', 'Chemicals', 'Cocaine', 'Codeine', 'Concentrates', 'Containers', 'Dihydrocodeine', 'Dissociatives', 'DMT', 'Doomsday', 'Drugs', 'Ecstasy', 'Edibles', 'Fentanyl', 'Filters', 'Fireworks', 'GBL', 'GHB', 'Grinders', 'Hash', 'Heroin', 'Hydrocodone', 'Hydromorphone', 'Injecting equipment', 'Ketamine', 'LSD', 'MDA', 'MDMA', 'Mephedrone', 'Mescaline', 'Meth', 'Morphine', 'Mushrooms', 'MXE', 'NB', 'Needles', 'Opioids', 'Opium', 'Oxycodone', 'Paper', 'Paraphernalia', 'PCP', 'Pills', 'Pipes', 'Prescription', 'Psychedelics', 'RCs', 'Salvia', 'Scales', 'Science', 'Seeds', 'Shake/trim', 'Smoked', 'Speed', 'Spores', 'Stashes', 'Steroids', 'Stimulants', 'Synthetics', 'Syringes', 'Weed', 'Weight loss') ) ''' ) comparison_df = dataframe. OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ( Connection refused)")Ĭomparison_df = db. traceback ) -> 921 raise excĩ22 923 # If e is neither DatabaseError or IOError, It's a bug.
format_exc ( ) 920 if DEBUG : print (exc. connect ( ) 679 680 def _create_ssl_ctx (self, sslp ) : /usr/local/lib/python3.4/dist-packages/pymysql/connections.py in connect (self, sock) 919 exc. usr/local/lib/python3.4/dist-packages/pymysql/connections.py in _init_ (self, host, user, password, database, port, unix_socket, charset, sql_mode, read_default_file, conv, use_unicode, client_flag, cursorclass, init_command, connect_timeout, ssl, read_default_group, compress, named_pipe, no_delay, autocommit, db, passwd, local_infile, max_allowed_packet, defer_connect, auth_plugin_map) 676 self. > 88 return Connection ( *args, **kwargs ) 89 90 from pymysql import connections as _orig_conn cursor ( ) /usr/local/lib/python3.4/dist-packages/pymysql/_init_.py in Connect (*args, **kwargs) 86 """ notebooks/logic.py in () -> 1 import settingsĥ 'g' : /notebooks/settings.py in () 19 20 -> 21 connection = pymysql. display import display, HTMLġ0 from db_patches import db_patches_list OperationalError Traceback (most recent call last)Ģ from IPython. connect (sa ) 504 return sockĬonnectionRefusedError: Connection refusedĭuring handling of the above exception, another exception occurred:
> 874 (self.host, self.port), nnect_timeout)Ĩ75 break /usr/lib/python3.4/socket.py in create_connection (address, timeout, source_address) 511 if err is not None : -> 512 raise errĥ13 else : /usr/lib/python3.4/socket.py in create_connection (address, timeout, source_address) 502 sock. usr/local/lib/python3.4/dist-packages/pymysql/connections.py in connect (self, sock) 873 sock = socket.create_connection( ConnectionRefusedError Traceback (most recent call last)
0 kommentar(er)
