In [6]:

    

import pandas as pd

import os

input_file = "input/input.xlsx"

df = pd.read_excel(input_file)
print(df.TypeAction.unique())


    

    




['Comment' 'Like']

In [7]:

    

comments = df.loc[df['TypeAction'] == 'Comment']
likes = df.loc[df['TypeAction'] == 'Like']

print(comments.head())
print(likes.head())


    

    




                                     Action_id TypeAction      Page_name  \
0    Comment/1364017066952510_1364097753611108    Comment  Resident Evil   
1  Comment/10154797365350629_10154797373500629    Comment   Bandai Namco   
2    Comment/1365217000165850_1365754593445424    Comment  Resident Evil   
3    Comment/1364017066952510_1364061950281355    Comment  Resident Evil   
4    Comment/1365217000165850_1225502404193085    Comment  Resident Evil   

                                        Feed_message  \
0  [UK ONLY] To celebrate the release of Resident...   
1  We continue our Tales Of look back with Tales ...   
2  Are you afraid of the dark? Because you should...   
3  [UK ONLY] To celebrate the release of Resident...   
4  Are you afraid of the dark? Because you should...   

                  User_name  \
0             Ronald Briand   
1               Jon Imboden   
2  Claudia Alejandra Olguín   
3            David Lawrence   
4         Leandro Guilherme   

                             CommentsForItem_message Sentiment  \
0                                  Muy buena :)  (Y)     0.988   
1  I may be in the minority here, but I LOVE the ...     0.954   
2  mira Roberto Zeballos,  para probar en tu PEQU...    0.9527   
3                                   Sarah Amadeus :O    0.9402   
4  Aeee Paulo Lucas vou te dar de presente no seu...    0.9382   

  Action_created_time_qvdate  
0                 2017-01-05  
1                 2016-12-27  
2                 2017-01-07  
3                 2017-01-05  
4                 2017-01-08  
              Action_id TypeAction     Page_name  \
7765    Like/6938264959       Like        CAPCOM   
7766   Like/12040282146       Like             -   
7767   Like/49054165628       Like  Bandai Namco   
7768  Like/154718398250       Like             -   
7769  Like/285330833071       Like             -   

                                           Feed_message User_name  \
7765  The team at Capcom Vancouver want to wish ever...         -   
7766  Before it comes out, i playing all the horror ...         -   
7767  Surfs up! Boruto is bringing tsunami reinforce...         -   
7768  21 días para experimentar el miedo y el terror...         -   
7769  Before it comes out, i playing all the horror ...         -   

     CommentsForItem_message Sentiment Action_created_time_qvdate  
7765                       -         -                 2017-01-04  
7766                       -         -                 2017-01-05  
7767                       -         -                 2017-01-04  
7768                       -         -                 2017-01-04  
7769                       -         -                 2017-01-05