pivot

import pandas as pd

df = pd.read_csv('AVG_FINAL.csv')
df2 = pd.read_csv('COUNT.csv')

av = pd.read_csv('AVG_TIER.csv')
me = pd.read_csv('MED_TIER.csv')
print(pd.concat([av['AVG_Impressions_Followers'], av['AVG_Reach_Followers'],
                 av['AVG_Engagement_Impressions'], av['AVG_Engagement_Followers'], av['Count']], axis=1))
print(pd.concat([me['MED_Impressions_Followers'], me['MED_Reach_Followers'],
                 me['MED_Engagement_Impressions'], me['MED_Engagement_Followers'], me['Count']], axis=1))

gr = df2[df2['STORY'] == 1]
gr2 = df2[df2['STORY'] == 0]
pivot11 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='COUNT')
pivot12 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='COUNT')
pivot11 = pivot11.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res5 = pd.concat([pivot12, pivot11], sort=False, axis=1)

gr = df[df['STORY'] == 1]
gr2 = df[df['STORY'] == 0]

pivot = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Impressions_Followers')
pivot2 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Impressions_Followers')
pivot = pivot.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res1 = pd.concat([pivot2, pivot], sort=False, axis=1)
res1 = res1[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot3 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Reach_Followers')
pivot4 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Reach_Followers')
pivot3 = pivot3.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res2 = pd.concat([pivot4, pivot3], sort=False, axis=1)
res2 = res2[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot5 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Engagement_Impressions')
pivot6 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Engagement_Impressions')
pivot5 = pivot5.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res3 = pd.concat([pivot6, pivot5], sort=False, axis=1)
res3 = res3[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot7 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Engagement_Followers')
pivot8 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Engagement_Followers')
pivot7 = pivot7.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res4 = pd.concat([pivot8, pivot7], sort=False, axis=1)
res4 = res4[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot9 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Views_Impressions')
pivot10 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='AVG_Views_Impressions')
pivot9 = pivot9.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res6 = pd.concat([pivot10, pivot9], sort=False, axis=1)
res6 = res6[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]



res1.insert(loc=0, column='All', value=av['AVG_Impressions_Followers'].values)
res2.insert(loc=0, column='All', value=av['AVG_Reach_Followers'].values)
res3.insert(loc=0, column='All', value=av['AVG_Engagement_Impressions'].values)
res4.insert(loc=0, column='All', value=av['AVG_Engagement_Followers'].values)
res5.insert(loc=0, column='All', value=av['Count'].values)
res = pd.concat([res1,res2,res3,res4,res5,res6], sort=False, axis=1)


res.to_csv('AVG2.csv')

df = pd.read_csv('MED_FINAL.csv')

gr = df[df['STORY'] == 1]
gr2 = df[df['STORY'] == 0]

pivot = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Impressions_Followers')
pivot2 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Impressions_Followers')
pivot = pivot.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res1 = pd.concat([pivot2, pivot], sort=False, axis=1)
res1 = res1[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot3 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Reach_Followers')
pivot4 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Reach_Followers')
pivot3 = pivot3.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res2 = pd.concat([pivot4, pivot3], sort=False, axis=1)
res2 = res2[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot5 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Engagement_Impressions')
pivot6 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Engagement_Impressions')
pivot5 = pivot5.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res3 = pd.concat([pivot6, pivot5], sort=False, axis=1)
res3 = res3[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot7 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Engagement_Followers')
pivot8 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Engagement_Followers')
pivot7 = pivot7.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res4 = pd.concat([pivot8, pivot7], sort=False, axis=1)
res4 = res4[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

pivot9 = gr.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Views_Impressions')
pivot10 = gr2.pivot(index='TIER', columns='MEDIA_TYPE', values='MED_Views_Impressions')
pivot9 = pivot9.rename(index=str, columns={"IMAGE": "IMAGE_ST", "VIDEO": "VIDEO_ST"})
res6 = pd.concat([pivot10, pivot9], sort=False, axis=1)
res6 = res6[['IMAGE', 'VIDEO', 'CAROUSEL_ALBUM', 'IMAGE_ST', 'VIDEO_ST']]

res1.insert(loc=0, column='All', value=me['MED_Impressions_Followers'].values)
res2.insert(loc=0, column='All', value=me['MED_Reach_Followers'].values)
res3.insert(loc=0, column='All', value=me['MED_Engagement_Impressions'].values)
res4.insert(loc=0, column='All', value=me['MED_Engagement_Followers'].values)

res = pd.concat([res1,res2,res3,res4,res5,res6], sort=False, axis=1)
res.to_csv('MED2.csv')