:I am writing as program and getting key error : ‘signup_date’ which I am unable to understand
Here is my code:
import pandas as pd
# load the dataset
data = pd.read_csv('/content/WA_Fn-UseC_-Telco-Customer-Churn.csv')
data.head()
# Check for missing values
print(data.isnull().sum())
# Fill missing values
data['tenure'].fillna(data['tenure'].median(), inplace=True)
# convert categorical variable to numerical using One-Hot Encoding
data = pd.get_dummies(data, drop_first=True)
# check data types
print(data.dtypes)
# Convert 'signup_date' to datetime format and extract new features
data['signup_date'] = pd.to_datetime(data['signup_date'])
data['subscription_duration'] = (pd.to_datetime('today') - data['signup_date']).dt.days
# Create interaction features
data['tenure_contract'] = data['tenure'] * data['contract_type']
My Error:
import pandas as pd
# load the dataset
data = pd.read_csv('/content/WA_Fn-UseC_-Telco-Customer-Churn.csv')
data.head()
# Check for missing values
print(data.isnull().sum())
# Fill missing values
data['tenure'].fillna(data['tenure'].median(), inplace=True)
# convert categorical variable to numerical using One-Hot Encoding
data = pd.get_dummies(data, drop_first=True)
# check data types
print(data.dtypes)
# Convert 'signup_date' to datetime format and extract new features
data['signup_date'] = pd.to_datetime(data['signup_date'])
data['subscription_duration'] = (pd.to_datetime('today') - data['signup_date']).dt.days
# Create interaction features
data['tenure_contract'] = data['tenure'] * data['contract_type']
import pandas as pd
# load the dataset
data = pd.read_csv('/content/WA_Fn-UseC_-Telco-Customer-Churn.csv')
data.head()
# Check for missing values
print(data.isnull().sum())
# Fill missing values
data['tenure'].fillna(data['tenure'].median(), inplace=True)
# convert categorical variable to numerical using One-Hot Encoding
data = pd.get_dummies(data, drop_first=True)
# check data types
print(data.dtypes)
# Convert 'signup_date' to datetime format and extract new features
data['signup_date'] = pd.to_datetime(data['signup_date'])
data['subscription_duration'] = (pd.to_datetime('today') - data['signup_date']).dt.days
# Create interaction features
data['tenure_contract'] = data['tenure'] * data['contract_type']