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

Course Content

Data Manipulation using pandas

Data Manipulation using pandas

1. Preprocessing Data: Part I

What is Data Preprocessing?Types consistencyPoor Data PresentationManipulating StringsChallengeReplacing Specific ElementsSimultaneous ReplacementChallenge

2. Preprocessing Data: Part II

Logical InconsistencyRemoving RowsChallengeOutliersChallengeMissing ValuesFilling NA valuesChallenge

3. Grouping Data

What is Grouping Data?Grouping in pandas [1/2]ChallengeGrouping in pandas [2/2]ChallengeGrouping by Several ColumnsChallenge

4. Aggregating and Visualizing Data

Advanced Aggregation [1/2]ChallengeAdvanced Aggregation [2/2]ChallengeHistogramsChallengeBar and Scatter PlotsOther Types of GraphsChallenge 1Challenge 2

5. Joining Data

What is Joining Data?Left JoinRight JoinInner JoinOuter JoinConcatenation

Challenge

Try to apply the aquired knowledge to fix the first problematic column.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Everything was clear?

Section 1. Chapter 5
toggle bottom row

Challenge

Try to apply the aquired knowledge to fix the first problematic column.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Everything was clear?

Section 1. Chapter 5
toggle bottom row

Challenge

Try to apply the aquired knowledge to fix the first problematic column.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Everything was clear?

Try to apply the aquired knowledge to fix the first problematic column.

Task

You are given the Statvillage dataset. You need to convert the 'totinch' column' values to float type by replacing commas by dots. Follow the next steps:

  1. Select the 'totinch' column.
  2. Apply the str accessor to the chosen column.
  3. Replace the , symbols in the column values with the ..
  4. Convert type to float.

Section 1. Chapter 5
Switch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt