path_2 = 'Data_repository/Master_2.csv'
master = pd.read_csv(path_2)
other_data = pd.concat([pd.read_csv(path_1 + f) for f in os.listdir(path_1)])
master.set_index('Nos', inplace=True)
other_data.set_index(['Nos', 'Time'], inplace=True)
other_data = other_data['Count'].unstack('Time')
joined = pd.concat([master, other_data], axis=1)
joined = joined.sort_index(axis=1)
joined = joined.fillna(method='pad', axis=1)
delta = joined - joined.shift(axis=1).fillna(0)
print(delta)
Column and Row manipulation Python Pandas