Topics

• Reading files into pandas DataFrame
• Duplicated data
• Python and Excel
• Database Access
• Using .ix, .iloc, .loc, .at and .iat to access a DataFrame

Examples

• Read table into DataFrame
• Get unique values from a column.
• PostgreSQL Database access using psycopg2
• Format Excel files with xlsxwriter
• Using .iloc
• Using .loc