Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Managing an Incorrect Column | Preprocessing Data
Advanced Techniques in pandas

bookManaging an Incorrect Column

So, you received the result object. This means that the type of the column is non-numerical, but to calculate necessary values, the column need to be numerical. Let's change that.

  1. Firstly, we need to replace - with .. To do so, you will apply the method .str.replace() to replace the character in the string in the dataset column. The syntax is
    data['column_name'].str.replace('old_symbol','new_symbol')
    In our case, old_symbol is -, and . is the new_symbol;
  2. Then, convert the column to the float data type. To do so, use .astype() method. The syntax is data['column_name'].astype('type').
    In our case, the type is 'float'.
Task

Swipe to start coding

Your task is to:

  1. Follow the algorithm above and firstly replace - with . in the column 'Fare'.
  2. Convert the column 'Fare' to the 'float' data type.
  3. Output the type of the column 'Fare'.

Solution

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 5. ChapterΒ 8
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Can you show me how to apply these changes to a specific column?

What should I do if there are missing values in the column?

Is there a way to check if the conversion was successful?

close

Awesome!

Completion rate improved to 3.03

bookManaging an Incorrect Column

Swipe to show menu

So, you received the result object. This means that the type of the column is non-numerical, but to calculate necessary values, the column need to be numerical. Let's change that.

  1. Firstly, we need to replace - with .. To do so, you will apply the method .str.replace() to replace the character in the string in the dataset column. The syntax is
    data['column_name'].str.replace('old_symbol','new_symbol')
    In our case, old_symbol is -, and . is the new_symbol;
  2. Then, convert the column to the float data type. To do so, use .astype() method. The syntax is data['column_name'].astype('type').
    In our case, the type is 'float'.
Task

Swipe to start coding

Your task is to:

  1. Follow the algorithm above and firstly replace - with . in the column 'Fare'.
  2. Convert the column 'Fare' to the 'float' data type.
  3. Output the type of the column 'Fare'.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

close

Awesome!

Completion rate improved to 3.03
SectionΒ 5. ChapterΒ 8
single

single

some-alt