Python Pandas: data analysis, transformation and cleaning

Mentored Online Training with Certification

// LEARN WITH US

What can you expect from the course?

You'll get familiar with the Jupyter Notebook development environment, where you create Python programmes for efficient data analysis and data cleaning.

You will master the proper spelling of Python language, and the time-saving techniques & shortcut keys which ensure faster coding.

You will learn how to easily analyze, filter, transform and clean data tables with even millions of rows using the Pandas library.

You will be proficient in managing Conditions (If ... Then ...) and creating Loops.

You will learn to create your own custom functions, which you can use to simplify frequently repeated tasks.

You will be confident in managing Lists and Dictionaries, with which you can flexibly store and manipulate data while the program is running.

Your
future mentor

Our training instructors are all professionals from industry leading technology companies (Microsoft, Evosoft, Autsoft, Telekom, EPAM, Starschema, Interactive Brokers, etc.) with an average of more than 10 years of practical experience.

// LEARN WITH US

How will you learn?

What you can learn at home, remotely, flexibly, why should you sit in a (virtual) training room and listen to it?
The knowledge required to complete the course is provided in the form of digital teaching materials (e.g. guided coding videos) via an online educational platform used by 300.000+ students.

Each week, you have to do countless practice tasks to apply the fresh knowledge already on the go.
The processing of the teaching materials and performing the practice projects require approx. 8-12 hours of investment per week.

During the course, you will receive feedback from the instructors to your uploaded projects (video or text form).
Also, you can ask from them anytime in writing and you can join their weekly live sessions where you can discuss the current projects or the difficulties, even by sharing your screen.

Each course has an own Discord group where you can share your experience with the others and where you can find partners to practice with.
However, we limit the number of participants per cohort, so the trainers can really support each of you.

At the end of the course you will have to complete an exam, which usually consists of a test and a practical exam task, based on the whole curriculum.
Upon successful completion, you will receive a personalized certificate that can be linked to your CV and Linkedin profile.

Why our students love to learn at Cubix Institute of Technology?

Why our students love to
learn at Cubix Institute of Technology?

Quality assured and curated course curriculum

Enthusiastic industry expert trainers and mentors

Industry-recognized certificate

Flexible schedule, online learning opportunities alongside work

Global community of IT professionals

Money back guarantee, interest free payment plans available

You will be in
good company!

Our students work for
major companies such as:

// DID YOU KNOW?

83% of employers finance staff training, don’t forget to ask yours!

Syllabus

The Anaconda Distribution (Anaconda Navigator)
The Jupyter Notebook development environment
Input methods
Spelling of Python code
Outputting data
Usage of variables
Useful time-saving keyboard shortcuts
The correct spelling of folders, file paths
Accessing folder contents – The “OS” module
Division, remainder
Exponentiation, square root

Converting to uppercase, lowercase
Removing unnecessary spaces
Replacing string parts
Searching for text in another text (contains, starts with, ends with)
Slicing strings (left, middle, right)
Splitting and concatenating strings
Formatting strings with curly braces: { }
Usage of the backslash: \

The “Pandas” library
Reading CSV files into Dataframes
Splitting Dataframe columns

Concatenating columns
Changing column data types
Deleting columns and rows
Renaming columns
Reordering column sequence
Adding new columns
Slicing and filtering Dataframes
Filtering Dataframe columns based on a text string
Sorting rows
Removing duplicates
Resetting the index
Inserting a new “ID” index column

Running other Python programs
Quickly replacing strings in Python code
Catching errors (TRY – EXCEPT)
Asking the user to input data (INPUT)
Creating and deleting folders in file system
Deleting files from file system

Notifications with beeping sound
Copying notebooks

Defining custom functions (def)
Measuring runtime
Custom “lambda” functions

Conditional (IF)
Binary variables
Loops (FOR)
Loops (WHILE)
Reading multiple files (e.g. all files in a folder)
Concatenating multiple files into one Dataframe

Reading, adding, modifying, deleting List items
Looping through List elements
Specific elements in a List
Deleting variables, Lists, etc. from memory
Concatenating strings from a List
Finding the difference between Lists

Reading data from Excel files into a Dataframe
Reading CSV files with special parameters into a Dataframe
Reading large size CSV files (several millions of rows) in chunks
Converting Dataframe columns to lists
Filtering Dataframe columns with a list
Merging two Dataframes
Iterating through Dataframe rows and columns with loops
Performing actions only on certain elements in the loop
Calculating values from the Dataframe column values (sum, count, average etc.)
Checking for differences between files (e.g. CSV)
Writing data to Excel files’ specific cells

Creating a Dictionary
Iterating through a Dictionary
Pairing Lists into a Dictionary
Removing duplicates from Lists with a Dictionary
Renaming Dataframe columns and data with a Dictionary

renaming dataframe columns or data with dictionary
looping through columns
looping through rows
loopring through certain files
creating template programs –
caluclating with column values
missing (blank) values in colums
aggregating column values (sum, average etc.)
aggregating row values
add ranges for values
aggregation by groups – pivot table
creating charts
finding differences between tables
the last row index in an excel table
writing to excel files’ specific cells
full learning material: Data analysis, data transformation
live session

// INDUSTRY-RECOGNIZED CERTIFICATE

Quality assured courses

The professional quality assurance of our trainings and the validation of our certificates are carried out by industry leader tech companies and one of the best technical universities in CEE region, the Budapest University of Technology and Economics who has been in electrical engineering and IT education for 70+ years.

Upon successful completion of the final exam of our courses, you will receive a certificate that can be linked to your CV and Linkedin profile.

It not only helps your professional progress by showing that you have mastered the given knowledge, but the very fact that you are doing something for your own development shows that you really want to be successful.

Nemes-Lehoczky Eszter Judit

You can get extremely useful knowledge from the course. The materials and explanations are well structured, easy to understand and follow.

Nemes-Lehoczky Eszter Judit

Student community

Our student community of more than 4000 members is made up mainly of people from industry leading IT companies and software development firms who want to continuously develop their existing skills.

Become a member of our community!

Frontend development with JavaScript

Well put together, practical learning material. I can continuously incorporate what I learn into my daily work. The LIVE sessions have even answered my questions not related to the curriculum

Zsolt Szigeti

Backend development with Java Spring boot

It was really quite "intense", but based on the videos and explanations, it was doable. Thanks for the experience!

Mate Kecskes

Python based software development

Very useful and I really enjoy it. I'm finally learning concrete things, without frills, in a concise and understandable way, that will make my work more effective tomorrow.

Eszter Kovacs

Backend development with Java Spring boot

I didn't think we'd cover so much before the big course, but it was worth taking part. It was very useful and covered a wide range of knowledge

Gabor Banrevi

Backend development with Java Spring boot

It was a great course. I learned a lot and I was able to use what I learned here.

Adam Veres

Course Details

Starting dates

The next dates are currently being negotiated, thank you for your patience!

In the meantime, subscribe if you would like to be notified when the next date of the course will be announced.

Or if you have any further questions, don’t hesitate to contact us via the link below or write to us directly to info@cubixedu.com!

// FINANCIAL SUPPORT

About payment

Secure online payment with credit or bank card via Stripe

One of the most common online payment solutions nowadays. Stripe is accredited with the Better Business Bureau and maintains an A+ rating, it is renowned for its speedy and secure payment processing

Interest-free installments

We don't want payment difficulties to hinder your professional development, so you can pay the participation fee in several installments, completely interest-free

Payment by bank transfer

If you want to pay by bank transfer instead of online card payment, that's no problem either, write to us and we'll help you with that too

Money-back guarantee

We are sure of the content and quality of the training, so we offer a 100% money-back guarantee for 8 days from the start of the training

Automatic e-invoicing

We automatically send you an e-invoice for online payment, but if you want to request a customized invoice or your company finances your training, contact us and we will help you arrange this

Referral discount

If someone refers you during enrollment, you both receive a guaranteed 10% discount on the training fee

Application process

Personal contact

If you’ve chosen to contact you personally before enrollment, then one of our colleagues will contact you via the contact details provided.

Consultation

We will help you to find the most suitable course(s) and payment construction options (installment, bundle discounts, etc.) for you.

Transaction

You will finalize your application by paying the tuition fee or the first installment via online payment or by bank transfer.

Onboarding

We provide you access to the online learning surface at the beginning of the course and also a comprehensive tutorial for a successful learning journey.

Personal contact

If you’ve chosen to contact you personally before enrollment, then one of our colleagues will contact you via the contact details provided.

Consultation

We will help you to find the most suitable course(s) and payment construction options (installment, bundle discounts, etc.) for you.

Transaction

You will finalize your application by paying the tuition fee or the first installment via online payment or by bank transfer.

Onboarding

We provide you access to the online learning surface at the beginning of the course and also a comprehensive tutorial for a successful learning journey.

// FOR EMPLOYERS

Are you looking for training for your employees?

No upcoming events