Python Programming

Class 7

INI File Structure [Configparser]

A configuration file consists of sections, each led by a [section] header, followed by key/value entries separated by a specific string.

[DEFAULT]
ServerAliveInterval = 45
Compression = yes
CompressionLevel = 9
ForwardX11 = yes

[bitbucket.org]
User = hg

[topsecret.server.com]
Port = 50022
ForwardX11 = no

source: https://docs.python.org/3/library/configparser.html

Load Credentials with Configparser

import configparser

#Load Credentials
config = configparser.ConfigParser()
config.sections()
config.read('Credentials.ini')
config.sections()

Connecting to MySQL Using Connector/Python

import mysql.connector

# Database
dbconfig = {
    'database': database,
    'user': user,
    'password': password,
    'host': host
}

# Conect to database
connection = mysql.connector.connect(**dbconfig)

• Keep connection arguments them in a dictionary and use the ** operator

Source: https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html

Read SQL query  into a DataFrame

#Consult query
df = pd.read_sql(sql, con=connection)

Source: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql.html

• sql: SQL query to be executed.

Pandas Arithmetic Functions

See Example

Source: https://pandas.pydata.org/pandas-docs/stable/basics.html

• sum()
• max()
• min()
• idxmax

Parse JSON into Python dict

import json

file_name = 'json_example.txt'
myfile = open(file_name, 'r')
json_example = myfile.read()
my_dict = json.loads(json_example)

Challenge

See on Evernote

Resources

• https://docs.python.org/3/library/configparser.html 
• https://dev.mysql.com/doc/connector-python/en/connector-python-example-connecting.html
• https://pandas.pydata.org/pandas-docs/stable/basics.html
• https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql.html