import pandas as pd
import numpy as np

# Set file paths for Titanic data (Source: Kaggle)
filepath_train = 'Data/train.csv'
filepath_test = 'Data/test.csv'

# Load train/test datasets as Pandas DataFrames
df_train = pd.read_csv('Data/train.csv', index_col='PassengerId')
df_test = pd.read_csv('Data/test.csv', index_col='PassengerId')

import pandas as pd
import numpy as np

# Set file paths for Titanic data (Source: Kaggle)
filepath_train = 'Data/train.csv'
filepath_test = 'Data/test.csv'

# Load train/test datasets as Pandas DataFrames
df_train = pd.read_csv('Data/train.csv', index_col='PassengerId')
df_test = pd.read_csv('Data/test.csv', index_col='PassengerId')

# Assign dataset labels as a new column
df_train['Dataset'] = 'Train'
df_test['Dataset'] = 'Test'

# Create a combined DataFrame by merging train/test sets
df_combined = pd.concat([df_train, df_test], axis=0)

Add Combined DataFrame by Merging Train/Test Sets
Add Combined DataFrame by Merging Train/Test Sets

Before merging, a new column was assigned to both sets with discrete values ['Train'/'Test'] that correspond to the set an observation is inclusive of.

  import pandas as pd
  import numpy as np
  
  # Set file paths for Titanic data (Source: Kaggle)
  filepath_train = 'Data/train.csv'
  filepath_test = 'Data/test.csv'
  
  # Load train/test datasets as Pandas DataFrames
  df_train = pd.read_csv('Data/train.csv', index_col='PassengerId')
  df_test = pd.read_csv('Data/test.csv', index_col='PassengerId')
  
+ # Assign dataset labels as a new column
+ df_train['Dataset'] = 'Train'
+ df_test['Dataset'] = 'Test'
+ 
+ # Create a combined DataFrame by merging train/test sets
+ df_combined = pd.concat([df_train, df_test], axis=0)
+ 
Add Combined DataFrame by Merging Train/Test Sets
## Code Before:
import pandas as pd
import numpy as np

# Set file paths for Titanic data (Source: Kaggle)
filepath_train = 'Data/train.csv'
filepath_test = 'Data/test.csv'

# Load train/test datasets as Pandas DataFrames
df_train = pd.read_csv('Data/train.csv', index_col='PassengerId')
df_test = pd.read_csv('Data/test.csv', index_col='PassengerId')

## Instruction:
Add Combined DataFrame by Merging Train/Test Sets
## Code After:
import pandas as pd
import numpy as np

# Set file paths for Titanic data (Source: Kaggle)
filepath_train = 'Data/train.csv'
filepath_test = 'Data/test.csv'

# Load train/test datasets as Pandas DataFrames
df_train = pd.read_csv('Data/train.csv', index_col='PassengerId')
df_test = pd.read_csv('Data/test.csv', index_col='PassengerId')

# Assign dataset labels as a new column
df_train['Dataset'] = 'Train'
df_test['Dataset'] = 'Test'

# Create a combined DataFrame by merging train/test sets
df_combined = pd.concat([df_train, df_test], axis=0)
