From the course: Complete Guide to Python for Data Engineering: From Beginner to Advanced

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Read files as DataFrames

Read files as DataFrames - Python Tutorial

From the course: Complete Guide to Python for Data Engineering: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Read files as DataFrames

“

- [Instructor] Picture Pandas as your data detective, a Schlock Holmes for spreadsheets. It can scan those files, gather the pieces, and assemble them into something called a DataFrame. It's like turning scattered nodes into a well organized story. A Pandas DataFrame is a two dimensional data structure, like a two dimensional array or just like a table with rules and column. Now, without wasting any time, let's get down to our Google collab notebook and see how Pandas work in real time. Assume that we have a CSV file and we want to read it via Panda's library. For this use case, the first step would be is to have that CSV loaded. Either you can click on this folder icon and use existing sample CSV or click on this upload to load your own file. This time let me load our own CSV file. Now, once this file gets loaded up here, right click on it and copy the file path. The first statement, which is needed to use the Pandas,…

Contents