Program Overview

Program Overview

The "Automation of Work with Text Data and Excel Tables using the Python Language" program is designed for individuals who want to learn how to effectively work with data of various formats and produce their visualization using Python. In today's world, where data plays a key role, the ability to conduct quick and accurate data analysis is becoming increasingly valuable.

Program Description

The program provides participants with all the necessary knowledge and skills to process, filter, and analyze tabular databases, text files, and PDF files. The course teaches participants the basics of Python syntax and standard functions of the Os, Pandas, Numpy, and Matplotlib libraries.

Program Objectives

After completing the course, participants will be able to use the acquired skills for quick and effective work with data, their analysis, and visualization, as well as apply the implemented algorithms in the educational or scientific process. These skills will be useful in a wide range of areas, from research work to industrial data analysis.

Program Structure

The program consists of 4 webinars with a total volume of 16 academic hours.

Webinar 1: Basics of Programming in Python

• Overview of the Jupyter Notebook development environment for working and running programs.
• Training in the necessary tools of the Python language.
• Learning to connect external modules for use in applications and create your own.

Webinar 2: Reading, Writing, and Managing Files for Various OS

• Consideration of file and directory management using Python language tools.
• Creation and optimization of the workspace.
• Discussion of the features of file space management on different operating systems.
• Learning to create and edit text documents.
• Learning to extract information from PDF documents.

Webinar 3: Working with Excel Tabular Data

• Practical example of reading, processing, and formatting data from an Excel table.
• Discussion of various ways to read "complex" tables.
• Learning to represent extracted data in a convenient format for work and perform necessary calculations.
• Study of methods for formatting the resulting table for presentation in a convenient format.

Webinar 4: Basics of Data Visualization

• Creation of basic illustrations from data arrays, both linear and multidimensional.
• Data visualization directly from tables using internal methods.
• Presentation of graphs for presentation and publication in a journal.

Program Benefits

• Training is conducted free of charge for scientific and pedagogical workers, masters, postgraduates, and administrative personnel.
• All participants who have completed the training receive a certificate of advanced training from the National Research Nuclear University MEPhI with a volume of 16 academic hours.
• Training is conducted by leading researchers of the National Research Nuclear University MEPhI.

Program Authors

• Lukyanov Alexander: Engineer of the Department of Solid State Physics and Nanosystems, Assistant of the Institute of Laser and Plasma Technologies of the National Research Nuclear University MEPhI.
• Neverov Vyacheslav: Engineer of the Department of Solid State Physics and Nanosystems, Assistant of the Institute of Laser and Plasma Technologies of the National Research Nuclear University MEPhI.
• Ryabov Pavel: Deputy Director of the Institute of Laser and Plasma Technologies, Associate Professor of the Department of Applied Mathematics, Ph.D.
• Kogos Konstantin: Head of the Digital Department of the National Research Nuclear University MEPhI, Deputy Director of the Institute of Intelligent Cybernetic Systems of the National Research Nuclear University MEPhI, Ph.D.