reviews-classifier/csv_reader_testes.py at master · mautoz/reviews-classifier · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
import pandas as pd

# Selecionando as colunas que interessam no CSV com o nome dos APPs e abrindo o CSV
colunas = ['appId', 'title']
apps_names = pd.read_csv('csv/apps.csv', usecols=colunas)
apps_names.dropna(inplace = True)
names = apps_names["appId"].str.find('ginlemon.smartlauncher.extratool')

# Buscando o título do APP pelo seu ID
names = apps_names.loc[apps_names["appId"] == 'ginlemon.smartlauncher.extratool']
nome = names.applymap(str).iloc[0,1]
print(f'= {nome}')

def find_app_name(appId):
    name_line = apps_names.loc[apps_names["appId"] == appId]
    return name_line.applymap(str).iloc[0,1]


# Google play store apps reviews
# Header do CSV: reviewId, userName, userImage, content, score, thumbsUpCount
# reviewCreatedVersion, at, replyContent, repliedAt, app_Id
reviews_columns = ['content', 'app_Id']
reviews = pd.read_csv('csv/google_play_store_apps_reviews.csv', usecols=reviews_columns, nrows=6)

for linha in range(len(reviews)):
    print(f'{reviews["content"][linha]} - {find_app_name(reviews["app_Id"][linha])}')

print(len(reviews))

# print(reviews["userName"][0])

# print(len(reviews))


# for line in range(len(reviews)):
#     print(f'{reviews["content"][line]} - {reviews["score"][line]} - {reviews["app_Id"][line]}')