Back

Sanskar

Keen Learner and Exp... • 20h

Day 14 of learning data science as a beginner. Topic: Melt, Pivot, Aggregation and Grouping Melt method in pandas is used to convert a wide format data into a long form data in simple words it represent different variables and combines them into key-value pairs. We need to convert data in order to feed it to our ML pipelines which may only take data in one format. Pivot is just the opposite of melt i.e. it turns long form data into a wide format data. Aggregation is used to apply multiple functions at once in our data for example calculating mean, maximum and minimum of the same data therefore instead of writing code for each of them we use .agg or .aggregate (in pandas both are exactly the same). Grouping as the name suggests groups the data into a specific group so that we can perform analysis in the group of similar data at once. Here's my code and its result.

Reply
1

More like this

Recommendations from Medial

Inayat Hasan

Software engineer • 1y

[This post has been deleted by the creator]

Reply
2

Sanskar

Keen Learner and Exp... • 5d

Day 10 of learning data science as a beginner Topic: data analysis using pandas Pandas is one of the python's most famous open source library and it is used for a variety of tasks like data manipulation, data cleaning and for analysis of data. Pand

See More
Reply
Image Description

036 -ECE-Joseph Rezenold

Hey I am on Medial • 7m

in web3 what kind of a freelancing we can do and convert it into agency or company

1 Reply
14
Image Description

Kevin Patel

Learner 🍂🤎 • 1y

Some one please guide me for the road map of the data science: Skill I do have right now is Python, numpy , pandas (learning) After completing pandas, numpy and Excel can I do freelancing.. It will be so helpful if someone guides me

2 Replies
5
Image Description

Baqer Ali

AI agent developer |... • 1m

Just made an automation that can create product images It just need the photo of the product It was a great experience for me Understood how to work with images in n8n Quick walk through First user will get the form the data will be given b

See More
1 Reply
2

Somen Das

Senior developer | b... • 1y

Array.reduce() is Goated the Swiss army knife Summing Numbers: Using reduce() to calculate the sum of numbers in an array. Flattening Arrays: Flattening a nested array into a single array. Grouping Objects: Grouping objects based on a speci

See More
Reply
5

Setu

Student | Freelancer... • 4m

The PNG format gets a long-awaited update after 20 years The World Wide Web Consortium has announced a major update to the Portable Network Graphics (PNG) image format after over two decades. Bringing official HDR support, animated PNGs, and improve

See More
Reply
3

Sanskar

Keen Learner and Exp... • 4d

Day 11 of learning Data science as a beginner Topic: creating data structure In my previous post I discussed about the difference between panda's series and data frames we typically use data frames more often as compared to series There are a lot

See More
Reply
2

Harish Kumar

Training Consoler • 10m

Python is a beginner-friendly and powerful programming language, perfect for diving into data science. Start by learning the basics like variables, loops, and functions. Explore popular libraries such as Pandas for data manipulation, NumPy for nume

See More
Reply
2

Sanskar

Keen Learner and Exp... • 1d

Day 13 of learning data science as a beginner. Topic: data cleaning and preprocessing In most of the real world applications we rarely get almost perfect data most of the time we get a raw data dump which needs to be cleaned and preprocessed before

See More
Reply
1

Download the medial app to read full posts, comements and news.