transformation_code.py

import pandas as pd

# Create a new dataframe named target_df
target_df = pd.DataFrame()

# Copy the 'case_date' column from source_df to the 'CaseDate' column in target_df without any transformation
target_df['CaseDate'] = source_df['case_date']

# Concatenate the 'firstname' and 'lastname' columns from source_df (with a space in between) and store the result in the 'FullName' column in target_df
target_df['FullName'] = source_df['firstname'] + " " + source_df['lastname']

# Copy the 'case_type' column from source_df to the 'CaseType' column in target_df without any transformation
target_df['CaseType'] = source_df['case_type']

# Return the target_df as the output of the script
target_df