Data Processing/Transformation: Complete Edition Python ETL



What you’ll learn

  • You will be able to understand how does transformation happens in industry.
  • You will be able to use PANDAS, a python library, to transform raw dataset into required format.
  • You will be able to use KNME, an analytical tool, to perform transformation.
  • You will be able to learn difference between using a tool and a programming language to perform transformation.

Course Content

  • Getting Started –> 1 lecture • 5min.
  • Basic Setup –> 3 lectures • 9min.
  • Python Basics –> 7 lectures • 1hr.
  • PANDAS Basics –> 14 lectures • 1hr 32min.
  • PANDAS Project –> 6 lectures • 52min.
  • KNIME –> 18 lectures • 1hr 37min.
  • KNIME Project –> 4 lectures • 45min.
  • Project (PANDAS) –> 5 lectures • 40min.
  • Project (KNIME) –> 5 lectures • 33min.

Auto Draft


  • No programming expertise needed..


My experience of working with huge data sets and different languages on projects of Fortune 500 companies made me realize that our college education, given its lack of focus on practice, does not prepare us for such rigor. Consequently, I struggled a lot through my initial years to come at par with what the industry required.

This course is a result of that struggle and is strictly focused on the industry-related application of programming. It involves the usage of the PANDAS library and KNIME tool which leads to ETL, i.e., the process of transforming big data into visuals.

You can start this new course, and I will try to assist you as much as possible in understanding the usage of these emerging tools. I want you all to know and understand that basic programming is not always the answer but instead, the application of smart tools is!


Here’s what you’ll learn in this course:

  • Python
  • PANDAS library
  • KNIME analytical tool
  • Side by side project in PANDAS and KNIME
  • And Way More!

This is a short course but nevertheless, it is a “Complete Guide” on data transformation. Through this course, we will ensure that any person with no knowledge of basic python concepts will be able to apply these in their real-life experiences or their full-time jobs.

We don’t believe in testing your knowledge through tricky tests rather we want you to develop this skill through its application. Therefore, we’ll go through concepts of Python, KNIME and PANDAS side by side and build two major projects.


There might be times when you get stuck. But I am here to help you get through it!

I am sure that nobody wants to go through a seven-hour course with not much sense to it. It is exactly why I wanted theory and practical implementation of each section properly in one short course! Not that I tried to explain the basics as I went through the course, I will be available to answer any queries that you might have in the comments section and help you get unstuck. I reply to every question to get you back on track.


Is this course for you?

  • If you want to learn how data transformation is used in the industry
  • If you want to learn libraries like PANDAS?
  • If you want to learn to work with tools like KNIME?

If the answer to all the above three is positive then chances are, that you’ll get a lot of value out of this course, too!

Get Tutorial