Managing 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.
- 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_symbolis-, and.is thenew_symbol; - Then, convert the column to the float
datatype. To do so, use.astype()method. The syntax isdata['column_name'].astype('type').
In our case, the type is'float'.
Swipe to start coding
Your task is to:
- Follow the algorithm above and firstly replace
-with.in the column'Fare'. - Convert the column
'Fare'to the'float'data type. - Output the type of the column
'Fare'.
Рішення
Дякуємо за ваш відгук!
single
Запитати АІ
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
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?
Awesome!
Completion rate improved to 3.03Managing 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.
- 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_symbolis-, and.is thenew_symbol; - Then, convert the column to the float
datatype. To do so, use.astype()method. The syntax isdata['column_name'].astype('type').
In our case, the type is'float'.
Swipe to start coding
Your task is to:
- Follow the algorithm above and firstly replace
-with.in the column'Fare'. - Convert the column
'Fare'to the'float'data type. - Output the type of the column
'Fare'.
Рішення
Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантівДякуємо за ваш відгук!
Awesome!
Completion rate improved to 3.03single
