it_handling.py

# Convert the data into a dataframe.
df = pd.DataFrame(data=test['data'])

# Derived attributes from the data.
df['dollarAmount'] = df['change']*df['transactionPrice']
df['insiderPortfolioChange'] = df['change']/(df['share'] - df['change'])

# print(type(df['transactionPrice'][0]))
conditions = [
    (df['change'] >= 0) & (df['transactionPrice'] > 0),
    (df['change'] <= 0) & (df['transactionPrice'] > 0),
    (df['transactionPrice'] == 0)
]
values = ['Buy', 'Sale', 'Gift']
df['buyOrSale'] = np.select(conditions, values)

print(df)

df.to_csv('YOUR PATH\\'+stock+'.csv', index=False)