Work with CSV, Excel and JSON

What you'll learn

How to use Python to access data stored in a variety of common formats.

How to read and write comma-separated value (CSV) files using both the Python Standard Library and pandas.

How to read and write javascript Object Notation (JSON) files using the Python Standard Library.

How to process JSON data received from an API.

Requirements

Basic Python knowledge

Description

Python is a widely used, general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in languages such as C++ or Java. The language provides constructs intended to enable clear programs on both a small and large scale.

This course makes it very easy to read popular file formats with Python. They include comma separated value (csv) files, excel files (xls, xlsx) and json data. If you want to take your Python skills to the next level, you should know how to work with various file formats.

It uses a step-by-step approach to teach these concepts. The course includes source code so you can try it on your own. It uses both the Python standard library as well as the Pandas module. As with many things in programming, there is more than one way to do it.

If you have just learned the basics of Python or OOP, this course is for you. You most likely will work with Excel and other file formats at some point. Especially because these formats are popular not only in office environment but also in web-apps and other type of applications.

Who this course is for:Python developers who want to learn how to access data from a range of file types.