Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lära Challenge | Time Series Data Processing
Data Preprocessing

book
Challenge

Uppgift

Swipe to start coding

Now, you know how to work with time-series data, and you are faced with the task of processing it:

  1. Convert column data type from str 'Month' to datetime.
  2. Fill NaN values using the interpolation method.
  3. Use the moving average method to remove noise from the data.

Lösning

import pandas as pd

# Read a dataset
dataset = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/9c23bf60-276c-4989-a9d7-3091716b4507/datasets/monthly-sunspots.csv')

# Convert 'Month' column to datetime format
dataset['Month'] = pd.to_datetime(dataset['Month'], format='%Y-%m')

# Interpolate missing values
dataset['Sunspots'] = dataset['Sunspots'].interpolate(method='linear')

# Remove noise from the data
dataset['Sunspots'] = dataset['Sunspots'].rolling(window=3).mean()

# Print the transformed dataset
print(dataset)

Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 6
import pandas as pd

# Read a dataset
dataset = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/9c23bf60-276c-4989-a9d7-3091716b4507/datasets/monthly-sunspots.csv')

# Convert 'Month' column to datetime format
dataset['Month'] = pd.___(dataset['Month'], format=___)

# Interpolate missing values
dataset['Sunspots'] = dataset['Sunspots'].___(method='linear')

# Remove noise from the data
dataset['Sunspots'] = dataset['Sunspots'].___(window=3).mean()

# Print the transformed dataset
print(dataset)

Fråga AI

expand
ChatGPT

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

some-alt