Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele Challenge | Preprocessing Data: Part II
Data Manipulation using pandas

book
Challenge

Let's replace the negative values in the 'empinch' and 'invsth' columns with zeros using the .where() method.

Tehtävä

Swipe to start coding

  1. Select the 'empinch' and 'invsth' columns.
  2. Apply the .where() method to chosen columns.
  3. Set the condition what values must be replaced (these must be negative values). Remember, values that don't satisfy this condition will be replaced.
  4. Set the parameter what values must be used instead of replaced ones.

Ratkaisu

# Importing the library
import pandas as pd

# Reading the file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/data3.csv')
# Perform a replacement
df[['empinch', 'invsth']] = df[['empinch', 'invsth']].where(~(df[['empinch', 'invsth']] < 0), other = 0)
# Analyze column values after replacement
print(df[['empinch', 'invsth']].describe())

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 2. Luku 5
# Importing the library
import pandas as pd

# Reading the file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/f2947b09-5f0d-4ad9-992f-ec0b87cd4b3f/data3.csv')
# Perform a replacement
df[['empinch', 'invsth']] = df[[___]].___((df[['empinch', 'invsth']] ___), other = ___)
# Analyze column values after replacement
print(df[['empinch', 'invsth']].describe())

Kysy tekoälyä

expand
ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

some-alt