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.
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.
Recommended: Python Essentials - Part 2 (Intermediate)
sqlite: What is a database, working with an SQLite database, creating databases; processing data.
Xml: Processing XML files, XML parsing, modifying and building XML documents.
Csv: The CSV module in Python, processing CSV files;.
Logging: Logging in Python, the logger object, logging levels, the setLevel method, basic configuration, handlers, formatters.
Configparser: The configparser module, the configuration file; parsing, processing the configuration file, interpolating values.
Associated Certification: PCPP1 – Certified Professional Python Programmer 1 (Exam 32-101)