Python online courses for analysts - course RUB 34,900. from the International School of Professions, training 2 weeks, date December 11, 2023.

Hello everyone :-) My name is Stanislav. Currently I live in the Tula region. I have several higher educations. Main - MSTU im. Bauman with a specialization in Computer Science and Control Systems. Second - Economic - Finance and credit. Third - Management of organizations. I have been working in IT for over 15 years. I started as a system administrator, system engineer. Worked in various large and international organizations, such as RAO UES, Yandex, Microsoft. Worked in different positions and directions. Completed projects of varying complexity. In recent years, my development vector has shifted from system administration to the implementation of web projects: I am involved in their creation and promotion. And of course, you have to use programming using Python, C#, JS, as well as SQL, CSS, HTML. At the moment, your favorite language is Python. I really love sharing knowledge and my experience. I have been teaching for the last 7 years. And I'm very glad that I became part of OTUS :-) Teacher

1. Introduction to Python syntax and conditional statements

Explore

1.Installation and interface of Jupyter Notebook
2.Basic constructs and variable types in Python
3.Data types
4.Operations with numbers and strings
5.Variables

Master it

• Jupyter Notebook
• Python
• Data types
• Variable types

On practice

• Let's study the functionality of the Jupyter Notebook interface.
• We will practice the simplest functions on tasks, learn how to perform operations and distinguish between data types.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

2. Python syntax. Continued: Loops, operators, modules

Explore

1.Logical operations and comparison operations
2.Conditions IF, ELSE, ELIF
3.Blocks and padding
4. Loops WHILE, FOR IN
5. Data structures: lists, dictionaries and tuples
6.Python functions: def
7.TIME and DATETIME modules

Master it

• Cycles
• Dictionaries and lists
• date and time
• Feature development

On practice

• We will practice new operations and cycles on tasks, and learn to integrate the acquired knowledge into work.
• Let's consider what you can implement into your own work and how to automate routine tasks.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

3. Pandas Software Library

Explore

1. Purpose and principles of working with the Pandas software library
2.Interface: necessary functionality
3.Pandas, NumPy, Matplotlib modules
4. Data structures
5.Creating Dataframe and Series
6. Data filtering with QUERY queries

Master it

• Pandas
• NumPy
• Matplotlib
• Dataframe

On practice

• Let's explore the functionality of Pandas using simple examples using Python.
• Let's create a Dataframe manually and load data from CSV, XLSX files.
• Load the HTML page into a dataframe.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

4. Pandas. Continued: calculating metrics, indexes, pivot tables

Explore

1.Calculation of basic metrics
2.Sorting data
3.Adding columns
4.Working with index: reset_index(), reindex(), nested indexes
5.Grouping data
6.Combining multiple Dataframes
7.Matplotlib visualization

Master it

• Metrics
• Indexes
• Pivot tables
• Grouping data

On practice

• We will work with the downloaded CSV file, learn how to calculate metrics, join tables and get acquainted with indexes using examples.
• Let's get some extra practice with dates and times.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

5. Selenium WebDriver

Explore

1.Import module, download driver file
2.Driver initialization and page loading
3.Pros and cons of working with Selenium. Alternatives
4.Searching for site elements using CSS selectors, classes and ids
5. Interaction with site elements
6. Obtaining information from site elements

Master it

• Selenium WebDriver
• Installing drivers
• CSS selectors
• Site elements

On practice

• Let's install Selenium WebDriver and figure out why the analyst needs it in his work.
• We will fill in the site data: sendkeys and button clicks.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

6. API - working with the application programming interface

Explore

1. Why does an analyst need to work with API?
2.How to get an API to work with Google. Analytics and Yandex. Metrica
3.How to authenticate
4.How to interpret the data
5.Automation

Master it

• API
• Requests module
• Dataframe
• Automation

On practice

• Let's study the Requests module and the get and post methods.
• Let's solve the problem of outputting data and placing it in a dataframe.
• Let's learn how to work with the VK API and download statistics from the group.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

7. Data visualization

Explore

1.Graphical functions for creating simple graphs
2.Visualization of analytical data
3.Presentation of findings
4.Choice of data presentation method
5.Types of graphs: histograms, line graphs

Master it

• Pandas graphics functions
• Matplotlib
• Seaborn
• Plotly

On practice

• Let's practice creating graphical functions using Pandas and create several types of graphs depending on the convenience of presenting information.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

8. Importing tables from PDF

Explore

1.Import of Glob and Tabula modules
2.How to get a list of all pdf files using python
3.How to work with a specific table from a pdf document
4. Correcting errors and adjusting the table
5.Combining dataframes
6.Camelot library - a way to extract tables

Master it

• Globe
• Tabula
• Import
• Camelot

On practice

• We will learn how to download a list of all pdf files on the computer in order to work with a specific file and table in the future.
• We will learn to read a pdf file and, if necessary, edit it to suit our needs. Let's write the file in .csv format.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

9. Git version control system

Explore

1.What is Git and what is it created for?
2.Git Benefits
3. Online hosting service for GitHub repositories
4. GitHub interface and basic functionality
5. Useful tools at work

Master it

• Git
• GitHub
• Pull Request
• Useful tools

On practice

• Let's install GitHub and look at its interface.
• Let's create our repository and upload the test code. Using his example, we will learn how to make commits, compare and roll back versions.
The teacher will evaluate the result of the assignment and discuss it with you in detail.

10. Summarizing

Explore

1.6 rules of good code
2.What soft-skills are needed for an analyst to work?
3. Recommendations on how to build your future path as a professional
4.Answers to prepared questions

Master it

• Python
• Analytics tools
• Soft skills
• Prospects

On practice

• Let's summarize the course together with the teacher.
The teacher will evaluate the result of the assignment and discuss it with you in detail.