About this course

Processing different kinds of text files

This course is the fifth in a 5-course series that will prepare you for the PCPP1 - Certified Professional in Python Programming 1 certification exam.

In this course you will learn the ways of processing different kinds of files and manipulating data in Python.

You will learn how to interact with SQLite databases (the sqlite3 module), create and process XML files (the xml module), read, write and process csv files (the csv module), create and process log messages from Python programs (the logging module), and manage configuration files (the configparser module).

After the course you will be able to work with different kinds of data files from various sources, and use them in projects requiring data manipulation and file processing. The course will help you gain skills and knowledge required in data analysis, software development, and troubleshooting.

You will learn

  • sqlite ‒ interacting with SQLite databases;
  • xml ‒ creating and processing XML files;
  • csv ‒ CSV file reading and writing;
  • logging ‒ basics logging facility for Python;
  • configparser ‒ configuration file parser.

Course Syllabus

What is a database, working with an SQLite database, creating databases; processing data;

Processing XML files, XML parsing, modifying and building XML documents;

The CSV module in Python, processing CSV files;

Logging in Python, the logger object, logging levels, the setLevel method, basic configuration, handlers, formatters;

The configparser module, the configuration file; parsing, processing the configuration file, interpolating values.

Certification

PCPP1 – Certified Professional in Python Programming 1 certification shows that the individual is familiar with the more advanced perspective of classes and features of object-oriented programming. The scope of certification also includes graphical user interface programming (TkInter), best practices and coding conventions (PEP 20, PEP 8, PEP 257), working with selected library modules allowing to process different kinds of files (xml, csv, sqlite3, logging, configparser), and utilizing tools and resources for the purposes of communicating with external resources and servers using the HTTP protocol and sockets (working with RESTful APIs).

Becoming PCPP1 certified ensures that the individual is fully acquainted with all the advanced means provided by Python 3 and related technologies to enable her/him to advance her/his career as a professional Python developer.

More information: https://pythoninstitute.org/certification/pcpp-certification-professional/

  • Channel: Edube Interactive
  • Sponsor: Python Institute
  • Mode: Online self-study course
  • Level: Intermediate/Advanced
  • Cost: Free
  • Study Time: 21 hours (Suggested: 2 hours a day)
  • Language: English
Share this course
Associated courses

PCPP1 | Advanced Perspective of Classes and Object-Oriented Programming (Professional 1/5)

PCPP1 | Best practices and Standardization (Professional 2/5)

PCPP1 | Introduction to GUI Programming in Python: TkInter (Professional 3/5)

PCPP1 | Working with RESTful APIs (Professional 4/5)

Pre-requisites

Recommended: Python Essentials - Part 2 (Intermediate)