From the course: Python for Marketing (2019)

Introduction to pandas - Python Tutorial

From the course: Python for Marketing (2019)

Start my 1-month free trial Buy for my team

Introduction to pandas

“

- [Instructor] Hello and welcome to the first video in this series. This video, we're going talk about the library we're going to use most often, and the data we're going to be using. So the library we use most often is pandas. Pandas is essentially Excel for Python. It can import so many data tapes, it can do so many things. And it can do very, very quickly. And this particular occasion, we're only going to be looking at CSV data. But we'll be looking at it from sources that you'll be seeing on a regular basis. Google Analytics, Google Search Console, AdWords, Facebook ads, with a couple other CSVs thrown in there that we can use for competitor analysis. Also be accessing an API for Google Trends. The data we're going to be using comes from my website, so there are some issues with it that you will need to fix. Some of those issues are dropping unnecessary columns of data, replacing numbers, replacing other values, fixing incorrectly recorded Google analytics page data. And we need to reformat some Team Series data in Google Analytics as well.

Contents