DEV Community

GharamElhendy
GharamElhendy

Posted on

Data Wrangling Techniques

#python #datascience

To drop certain irrelevant columns when analyzing a dataset 

df.drop(['ColumnX', 'ColumnY', 'ColumnZ'], axis=1, inplace=True)
Enter fullscreen mode Exit fullscreen mode

To count the number of values in a column 

df['Column_name'].value_counts()
Enter fullscreen mode Exit fullscreen mode

To change the value to numeric 

df['Column_name'] = pd.to_numeric(df['Column_name'])
Enter fullscreen mode Exit fullscreen mode

To replace certain values in a column to other values of choice 

df['Column_name'] = df['Column_name'].replace(['Initial_value'], 'New_value')
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

grantdotdev profile image

Advent of Code 2024 - Day 14 : Restroom Redoubt

Grant Riordan -

mikeyoung44 profile image

Brain-Inspired Method Cuts Neural Networks by 90% Without Losing Accuracy

Mike Young -

dhruvil_joshi14 profile image

React JS vs Python: How to Choose the Best Fit for Your Project

Dhruvil Joshi -

mfdupuis profile image

Who should be your first data hire and when should you hire them?

Marc Dupuis -