Data Cleaning and Preparation
Example Prompt:
Example Response:
import pandas as pd
df = pd.read_csv('path_to_file.csv')
library(readr)
df <- read_csv('path_to_file.csv')
print(df.head())
print(df.dtypes)
head(df)
str(df)
df.fillna(df.mean(), inplace=True) # Filling missing values with mean
df[is.na(df)] <- mean(df, na.rm = TRUE) # Filling missing values with mean
df.drop_duplicates(inplace=True)
df <- df[!duplicated(df), ]
df['date_column'] = pd.to_datetime(df['date_column']) # Standardizing date format
df$date_column <- as.Date(df$date_column, format='%Y-%m-%d') # Standardizing date format
import seaborn as sns
sns.boxplot(x=df['numeric_column']) # Visualizing outliers
boxplot(df$numeric_column) # Visualizing outliers
print(df.info())
str(df)
Related Tasks:
Generating Reports
Example Prompt:
Example Response:
Related Tasks:
Creating Technical Documentation
Example Prompt:
Example Response:
Related Tasks:
Preparing Communication Materials
Example Prompt:
Example Response:
Related Tasks:
Troubleshooting Technical Issues
Example Prompt:
Example Response:
print(df.head())
print(df.columns)
print('Before operation X')
# Your operation here
print('After operation X')
Related Tasks: