AhmedKhaled1122/Data-Analysis-and-Machine-Learning

1import pandas as pd2 3def load_data(file_path):4    file_name = file_path.name5 6    if file_name.endswith('.csv'):7        df = pd.read_csv(file_path, index_col=False)8    elif file_name.endswith('.xlsx') or file_name.endswith('.xls'):9        df = pd.read_excel(file_path, index_col=False)10    11    return df12 13def append_datasets(df):14    df = pd.concat(list(df), ignore_index=True)15    return df16 17def value_count(df):18    return df.nunique().sort_values()19 20def change_datatype(df, convert_dict):21    df = df.astype(convert_dict)22    return df23 24def inner_join(df1, df2, left_join, right_join):25    df = pd.merge(df1, df2, left_on=left_join, right_on=right_join, how='inner')26    return df27 28def cross_join(df1, df2, left_join, right_join):29    df = pd.merge(df1, df2,left_on=left_join, right_on=right_join, how='outer')30    return df31 32def left_join(df1, df2, left_join, right_join):33    df = pd.merge(df1, df2, left_on=left_join, right_on=right_join, how='left')34    return df35 36def right_join(df1, df2, left_join, right_join):37    df = pd.merge(df1, df2, left_on=left_join, right_on=right_join, how='right')38    return df39 40def index_join(df1, df2):41    df = pd.merge(df1, df2, left_index=True, right_index=True)42    return df43