回答編集履歴
2
結果例を追記
answer
CHANGED
|
@@ -62,4 +62,53 @@
|
|
|
62
62
|
csvwriter.writerow([session, item, lista[session][item].columns[0], lista[session][item].columns[1]])
|
|
63
63
|
lista[session][item].to_csv(csv_file, mode='a', header=False)
|
|
64
64
|
|
|
65
|
+
```
|
|
66
|
+
|
|
67
|
+
【結果例】
|
|
68
|
+
|
|
69
|
+
```csv
|
|
70
|
+
japan top query value
|
|
71
|
+
0,amazon japan,100
|
|
72
|
+
1,japanese,49
|
|
73
|
+
2,yahoo japan,45
|
|
74
|
+
3,from japan,41
|
|
75
|
+
4,japan store,40
|
|
76
|
+
5,sarku japan,35
|
|
77
|
+
6,hobbylink japan,24
|
|
78
|
+
7,nintendo japan,21
|
|
79
|
+
8,blue blue japan,15
|
|
80
|
+
9,japan blue,15
|
|
81
|
+
10,japan time,15
|
|
82
|
+
11,japan clothing,13
|
|
83
|
+
12,yahoo japan auctions,11
|
|
84
|
+
13,china,11
|
|
85
|
+
14,nike japan,11
|
|
86
|
+
15,ebay japan,11
|
|
87
|
+
16,japan movt,10
|
|
88
|
+
17,seiko japan,9
|
|
89
|
+
18,seiko,9
|
|
90
|
+
19,japan shirt,9
|
|
91
|
+
20,tokyo japan,8
|
|
92
|
+
21,japan movt watch,8
|
|
93
|
+
22,google japan,8
|
|
94
|
+
23,netflix japan,7
|
|
95
|
+
24,japan coronavirus,7
|
|
96
|
+
japan rising query value
|
|
97
|
+
0,japan recession,5350
|
|
98
|
+
1,dreamland japan,550
|
|
99
|
+
2,dreamland,550
|
|
100
|
+
3,dreamland in japan,400
|
|
101
|
+
4,hobbylink japan shipping,150
|
|
102
|
+
5,thank you in japan,90
|
|
103
|
+
6,solaris japan,80
|
|
104
|
+
7,nori japan,80
|
|
105
|
+
8,suits japan,80
|
|
106
|
+
9,japan borders open,80
|
|
107
|
+
10,hobbylink japan,70
|
|
108
|
+
11,nintendo land japan,70
|
|
109
|
+
12,crunchyroll store,60
|
|
110
|
+
13,sarku japan hours,60
|
|
111
|
+
14,mastermind japan,60
|
|
112
|
+
15,japan store,60
|
|
113
|
+
16,sarku japan,50
|
|
65
114
|
```
|
1
一応、組み合わせてみたバージョンを追記
answer
CHANGED
|
@@ -41,4 +41,25 @@
|
|
|
41
41
|
|
|
42
42
|
【参考】
|
|
43
43
|
- [What kind of data does pandas handle?](https://pandas.pydata.org/docs/getting_started/intro_tutorials/01_table_oriented.html#min-tut-01-tableoriented)
|
|
44
|
-
- [pandasでcsvファイルの書き出し・追記（to_csv） | note.nkmk.me](https://note.nkmk.me/python-pandas-to-csv/)
|
|
44
|
+
- [pandasでcsvファイルの書き出し・追記（to_csv） | note.nkmk.me](https://note.nkmk.me/python-pandas-to-csv/)
|
|
45
|
+
|
|
46
|
+
【一応、組み合わせてみたバージョン】
|
|
47
|
+
```python
|
|
48
|
+
import csv
|
|
49
|
+
from pytrends.request import TrendReq
|
|
50
|
+
pytrends = TrendReq()
|
|
51
|
+
|
|
52
|
+
kw_list = ["japan"]
|
|
53
|
+
pytrends.build_payload(kw_list, cat=18, timeframe='now 7-d', geo='US')
|
|
54
|
+
|
|
55
|
+
lista = pytrends.related_queries()
|
|
56
|
+
|
|
57
|
+
#csvとして出力する
|
|
58
|
+
with open('TrendJapan.csv', 'w') as csv_file:
|
|
59
|
+
csvwriter = csv.writer(csv_file, delimiter='\t')
|
|
60
|
+
for session in lista:
|
|
61
|
+
for item in lista[session]:
|
|
62
|
+
csvwriter.writerow([session, item, lista[session][item].columns[0], lista[session][item].columns[1]])
|
|
63
|
+
lista[session][item].to_csv(csv_file, mode='a', header=False)
|
|
64
|
+
|
|
65
|
+
```
|