New Everyday Python

The goal of the “Everyday Python” course is to enable participants to quickly and efficiently solve their daily—often tedious and repetitive—tasks using Python.

For example: Reading data from CSV, XLSX files, or a database, performing operations on the data, then creating charts from the results and sending them via email, possibly with additional predictions. All automated.

During the course, participants will learn about pandas, Matplotlib/Seaborn libraries, database management options, email automation, and predictive capabilities offered by language models. The course places special emphasis on real-world, practical examples that participants can immediately apply in their own work.

1. Data Handling with pandas

• DataFrame and Series structures
• Loading data from various sources (CSV, Excel, SQL)
• Data cleaning and transformation
• Aggregation and grouping

2. Data Visualization with Matplotlib and Seaborn

• Creating basic charts (line, bar, scatter plots)
• Visualizing data with Seaborn: heatmaps, boxplots
• Customizing and saving charts

3. Automating Emails

• Using SMTP client in Python
• Handling recipients and attachments

4. CSV and XLSX File Handling

• Reading and writing files
• Exporting data and format conversion
• Handling large datasets

5. Database Management

• Connecting to SQL databases
• Creating and executing queries
• Loading and saving data from/to databases

6. GML

• Analyzing large datasets and making predictions based on practical examples

English language skills at document reading level. Completion of Training 360 Python PR-PY course or equivalent within 1 year, or day-to-day Python programming experience of at least 1 year.