Replacing Characters
Just as we removed characters, there are also two ways to perform replacements: either by using the .str accessor or by using a lambda function. Since we are only performing the replacement for one column, let's use the first approach.
Tehtävä
Swipe to start coding
-
Replace the commas with dots in the
'CPI'column. Follow these steps:- Select the
'CPI'column; - Use the
.straccessor; - Replace the
','symbols with'.'using the.replace()method; - Convert the values to
floattype; - Assign the obtained result to the
'CPI'column.
- Select the
-
Display the first row of the
dfdataframe and data types of thedfdataframe.
Ratkaisu
99
1
2
3
4
5
6
7
8
9
10
11
12
# Load the library
import pandas as pd
# Read the data
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/72be5dde-f3e6-4c40-8881-e1d97ae31287/shops_data1.csv')
# Convert the 'CPI' column into numerical
df['CPI'] = df['CPI'].str.replace(',', '.').astype(float)
# Display the first row of dataframe and dtypes
print(df.head(1))
print(df.dtypes)
Oliko kaikki selvää?
Kiitos palautteestasi!
Osio 1. Luku 7
99
1
2
3
4
5
6
7
8
9
10
11
12
# Load the library
import pandas as pd
# Read the data
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/72be5dde-f3e6-4c40-8881-e1d97ae31287/shops_data1.csv')
# Convert the 'CPI' column into numerical
df['___'] = df['___'].___.___('___', '___').___(___)
# Display the first row of dataframe and dtypes
print(df.head(___))
print(df.___)
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
