ADAP1

import pandas as pd

# Create a DataFrame from a dictionary
data = {
    'A': [1, 2, 3],
    'B': [4, 5, 6],
    'C': [7, 8, 9]
}

df = pd.DataFrame(data)
print("Original DataFrame:\n", df)
--------------------------------------------------
df_add = df + 10
df_squared = df ** 2
print(df_add)
print(df_squared)
--------------------------------------------------
row_sum = df.sum(axis=1)   # Row-wise sum
print(row_sum)
col_mean = df.mean()       # Column-wise mean
print(col_mean)
--------------------------------------------------
df_T = df.T
print(df_T)
--------------------------------------------------
df1 = pd.DataFrame({
    'ID': [1, 2, 3],
    'Name': ['Alice', 'Bob', 'Charlie']
})

df2 = pd.DataFrame({
    'ID': [1, 2, 4],
    'Marks': [85, 90, 78]
})
print(df1)
print(df2)
--------------------------------------------------
merged_df = pd.merge(df1, df2, on='ID', how='inner')   # Only matching rows
print(merged_df)
merged_outer = pd.merge(df1, df2, on='ID', how='outer')  # All rows
print(merged_outer)