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

mikeyoung44 profile image

Revolutionary Differential Transformer Boosts AI Performance with Focused Attention Mechanism

Mike Young -

hyperkai profile image

Warning in Python

Super Kai (Kazuya Ito) -

khai-jt profile image

Move hardcoded secrets to a Secrets Manager

Khai J. Thani -

adithya_a_508b89c3885ee40 profile image

Transform Your Text Analysis Journey: How KeyBERT is Changing the Game for Keyword Extraction!

Adithya A -