Showing posts with label Pandas. Show all posts
Showing posts with label Pandas. Show all posts

Tuesday 13 February 2024

Pandas in Action


Take the next steps in your data science career! This friendly and hands-on guide shows you how to start mastering Pandas with skills you already know from spreadsheet software.

In Pandas in Action you will learn how to:

    Import datasets, identify issues with their data structures, and optimize them for efficiency

    Sort, filter, pivot, and draw conclusions from a dataset and its subsets

    Identify trends from text-based and time-based data

    Organize, group, merge, and join separate datasets

    Use a GroupBy object to store multiple DataFrames

Pandas has rapidly become one of Python's most popular data analysis libraries. In Pandas in Action, a friendly and example-rich introduction, author Boris Paskhaver shows you how to master this versatile tool and take the next steps in your data science career. You'll learn how easy Pandas makes it to efficiently sort, analyze, filter and munge almost any type of data.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

About the technology

Data analysis with Python doesn't have to be hard. If you can use a spreadsheet, you can learn pandas! While its grid-style layouts may remind you of Excel, pandas is far more flexible and powerful. This Python library quickly performs operations on millions of rows, and it interfaces easily with other tools in the Python data ecosystem. It's a perfect way to up your data game.

About the book

Pandas in Action introduces Python-based data analysis using the amazing pandas library. You'll learn to automate repetitive operations and gain deeper insights into your data that would be impractical—or impossible—in Excel. Each chapter is a self-contained tutorial. Realistic downloadable datasets help you learn from the kind of messy data you'll find in the real world.

What's inside

    Organize, group, merge, split, and join datasets

    Find trends in text-based and time-based data

    Sort, filter, pivot, optimize, and draw conclusions

    Apply aggregate operations

About the reader

For readers experienced with spreadsheets and basic Python programming.

About the author

Boris Paskhaver is a software engineer, Agile consultant, and online educator. His programming courses have been taken by 300,000 students across 190 countries.

Table of Contents


1 Introducing pandas

2 The Series object

3 Series methods

4 The DataFrame object

5 Filtering a DataFrame


6 Working with text data

7 MultiIndex DataFrames

8 Reshaping and pivoting

9 The GroupBy object

10 Merging, joining, and concatenating

11 Working with dates and times

12 Imports and exports

13 Configuring pandas

14 Visualization

Hard Copy: Pandas in Action

Sunday 18 June 2023

Data Analytics Course Handwritten Notes


In today's digital age, where typing on keyboards and tapping on screens has become the norm, there is something truly magical about the simplicity and authenticity of handwritten notes. Handwritten notes have a unique charm that digital text cannot replicate. They are a reflection of our personality, creativity, and individuality. In this blog, I want to share my newfound love for handwritten notes and the joy they bring.

The Art of Handwriting:

Handwriting is an art form that allows us to express ourselves in a personal and intimate way. Each stroke of the pen carries a piece of our emotions, thoughts, and ideas. Whether it's elegant cursive, playful doodles, or colorful illustrations, our handwriting reveals a glimpse of our character. Handwritten notes offer a tangible connection between the writer and the reader, creating a more intimate and meaningful experience.

Unleashing Creativity:

Writing by hand stimulates our creativity and imagination. As we put pen to paper, ideas flow more freely, and we are more likely to explore new perspectives and insights. The act of writing itself becomes a therapeutic process, allowing us to slow down, focus, and fully engage with our thoughts. Handwritten notes offer a canvas for our creativity to flourish, enabling us to experiment with different styles, fonts, and embellishments.

A Personal Touch:

When we receive a handwritten note, it feels like a precious gift. The time and effort invested in crafting the note make it a unique and personal gesture. Whether it's a heartfelt letter, a thoughtful thank-you card, or a quick reminder, handwritten notes show that we care. They create a deeper connection and leave a lasting impression on the recipient, unlike impersonal digital messages that can easily be forgotten.

Preserving Memories:

Handwritten notes have an enduring quality that transcends time. They become treasured keepsakes, reminding us of special moments, important milestones, and cherished relationships. Stumbling upon a box of old handwritten letters can evoke a wave of nostalgia and bring back vivid memories. In a world where digital files can be lost or corrupted, handwritten notes stand as tangible and irreplaceable mementos of our lives.

Sharing Handwritten Notes:

In the spirit of celebrating the beauty of handwritten notes, I am excited to share my own collection of handwritten notes with you all. Through my blog and social media platforms, I will be posting images and stories behind my notes, discussing different techniques and styles, and even providing tips on improving handwriting skills. I hope to inspire others to rediscover the joy of writing by hand and to embrace the personal touch that handwritten notes bring to our lives.


Handwritten notes are not merely pieces of paper; they are vessels of our thoughts, emotions, and creativity. They allow us to connect on a deeper level, create lasting memories, and express ourselves in a way that digital text cannot replicate. So, let's bring back the beauty of handwritten notes, one stroke of the pen at a time, and embrace the power of personal expression. Together, let's make the world a little brighter with our handwritten notes.

Tuesday 5 October 2021

Operations On Dataframe in Python

Checking data types of each Column in a Data Frame.

  • If you want to check the data type of each column, because whenever you have been given a data, you want to really check what is the structure of the data; that means, which variable has which data type?
  • In, that case you can use dtypes, because that returns a series with the data type of each column and the syntax would be you use dtypes along with the Data Frame name.
  • So, Data Frame.dtypes will give you a series with the data type of each column

Here is the syntax.

Syntax = DataFrame.dtypes


Count of unique data types

  • So, now we have an overall idea about what are the data types that we are going to work with using the cars_data. 
  • There is also an option where you can get the count of unique data types available in your Data Frame.
  • So, in that case get_dtype_counts, returns the counts of unique data types in the data frame.

Here is the syntax.

Syntax = get_dtype_counts()

Selecting data based on data types

  • So, now we also have an overall idea about the count of unique data types that we are going to handle with. 

  • So, now, we know about how to get the data type of each variables. So, there might be cases where you want to perform the operations only on a numerical data type.

  • Similarly, there can be cases where you are going to work with only categorical data type.

Here is the syntax.

Syntax =

Join us:

Popular Posts


AI (27) Android (24) AngularJS (1) Assembly Language (2) aws (17) Azure (7) BI (10) book (4) Books (117) C (77) C# (12) C++ (82) Course (62) Coursera (180) Cybersecurity (22) data management (11) Data Science (95) Data Strucures (6) Deep Learning (9) Django (6) Downloads (3) edx (2) Engineering (14) Excel (13) Factorial (1) Finance (6) flutter (1) FPL (17) Google (19) Hadoop (3) HTML&CSS (46) IBM (25) IoT (1) IS (25) Java (92) Leet Code (4) Machine Learning (44) Meta (18) MICHIGAN (5) microsoft (4) Pandas (3) PHP (20) Projects (29) Python (753) Python Coding Challenge (228) Questions (2) R (70) React (6) Scripting (1) security (3) Selenium Webdriver (2) Software (17) SQL (40) UX Research (1) web application (8)


Person climbing a staircase. Learn Data Science from Scratch: online program with 21 courses