import pandas as pd import numpy as np # Load the data into a DataFrame df = pd.DataFrame({'Name': ['Ali', 'John', 'Gaurav', 'Raj', 'Ravi', 'Natasha', 'Aliya'], 'Age': [17, 17, 18, 17, 18, 17, 17], 'Gender': ['M', 'M', 'M', 'M', 'M', 'F', 'F'], 'Marks': [90, 76, np.nan, 74, 65, np.nan, 71]}) # Inspect the data print(df.info()) # Handle missing values df = df.replace(np.nan, -1) print(df)
# Convert data types try: df['Age'] = df['Age'].astype('int64') df['Marks'] = df['Marks'].astype('int64') except ValueError: print('Cannot convert data types') print(df.info())