回答編集履歴
2
結果例を追記
test
CHANGED
|
@@ -127,3 +127,101 @@
|
|
|
127
127
|
|
|
128
128
|
|
|
129
129
|
```
|
|
130
|
+
|
|
131
|
+
|
|
132
|
+
|
|
133
|
+
【結果例】
|
|
134
|
+
|
|
135
|
+
|
|
136
|
+
|
|
137
|
+
```csv
|
|
138
|
+
|
|
139
|
+
japan top query value
|
|
140
|
+
|
|
141
|
+
0,amazon japan,100
|
|
142
|
+
|
|
143
|
+
1,japanese,49
|
|
144
|
+
|
|
145
|
+
2,yahoo japan,45
|
|
146
|
+
|
|
147
|
+
3,from japan,41
|
|
148
|
+
|
|
149
|
+
4,japan store,40
|
|
150
|
+
|
|
151
|
+
5,sarku japan,35
|
|
152
|
+
|
|
153
|
+
6,hobbylink japan,24
|
|
154
|
+
|
|
155
|
+
7,nintendo japan,21
|
|
156
|
+
|
|
157
|
+
8,blue blue japan,15
|
|
158
|
+
|
|
159
|
+
9,japan blue,15
|
|
160
|
+
|
|
161
|
+
10,japan time,15
|
|
162
|
+
|
|
163
|
+
11,japan clothing,13
|
|
164
|
+
|
|
165
|
+
12,yahoo japan auctions,11
|
|
166
|
+
|
|
167
|
+
13,china,11
|
|
168
|
+
|
|
169
|
+
14,nike japan,11
|
|
170
|
+
|
|
171
|
+
15,ebay japan,11
|
|
172
|
+
|
|
173
|
+
16,japan movt,10
|
|
174
|
+
|
|
175
|
+
17,seiko japan,9
|
|
176
|
+
|
|
177
|
+
18,seiko,9
|
|
178
|
+
|
|
179
|
+
19,japan shirt,9
|
|
180
|
+
|
|
181
|
+
20,tokyo japan,8
|
|
182
|
+
|
|
183
|
+
21,japan movt watch,8
|
|
184
|
+
|
|
185
|
+
22,google japan,8
|
|
186
|
+
|
|
187
|
+
23,netflix japan,7
|
|
188
|
+
|
|
189
|
+
24,japan coronavirus,7
|
|
190
|
+
|
|
191
|
+
japan rising query value
|
|
192
|
+
|
|
193
|
+
0,japan recession,5350
|
|
194
|
+
|
|
195
|
+
1,dreamland japan,550
|
|
196
|
+
|
|
197
|
+
2,dreamland,550
|
|
198
|
+
|
|
199
|
+
3,dreamland in japan,400
|
|
200
|
+
|
|
201
|
+
4,hobbylink japan shipping,150
|
|
202
|
+
|
|
203
|
+
5,thank you in japan,90
|
|
204
|
+
|
|
205
|
+
6,solaris japan,80
|
|
206
|
+
|
|
207
|
+
7,nori japan,80
|
|
208
|
+
|
|
209
|
+
8,suits japan,80
|
|
210
|
+
|
|
211
|
+
9,japan borders open,80
|
|
212
|
+
|
|
213
|
+
10,hobbylink japan,70
|
|
214
|
+
|
|
215
|
+
11,nintendo land japan,70
|
|
216
|
+
|
|
217
|
+
12,crunchyroll store,60
|
|
218
|
+
|
|
219
|
+
13,sarku japan hours,60
|
|
220
|
+
|
|
221
|
+
14,mastermind japan,60
|
|
222
|
+
|
|
223
|
+
15,japan store,60
|
|
224
|
+
|
|
225
|
+
16,sarku japan,50
|
|
226
|
+
|
|
227
|
+
```
|
1
一応、組み合わせてみたバージョンを追記
test
CHANGED
|
@@ -85,3 +85,45 @@
|
|
|
85
85
|
- [What kind of data does pandas handle?](https://pandas.pydata.org/docs/getting_started/intro_tutorials/01_table_oriented.html#min-tut-01-tableoriented)
|
|
86
86
|
|
|
87
87
|
- [pandasでcsvファイルの書き出し・追記（to_csv） | note.nkmk.me](https://note.nkmk.me/python-pandas-to-csv/)
|
|
88
|
+
|
|
89
|
+
|
|
90
|
+
|
|
91
|
+
【一応、組み合わせてみたバージョン】
|
|
92
|
+
|
|
93
|
+
```python
|
|
94
|
+
|
|
95
|
+
import csv
|
|
96
|
+
|
|
97
|
+
from pytrends.request import TrendReq
|
|
98
|
+
|
|
99
|
+
pytrends = TrendReq()
|
|
100
|
+
|
|
101
|
+
|
|
102
|
+
|
|
103
|
+
kw_list = ["japan"]
|
|
104
|
+
|
|
105
|
+
pytrends.build_payload(kw_list, cat=18, timeframe='now 7-d', geo='US')
|
|
106
|
+
|
|
107
|
+
|
|
108
|
+
|
|
109
|
+
lista = pytrends.related_queries()
|
|
110
|
+
|
|
111
|
+
|
|
112
|
+
|
|
113
|
+
#csvとして出力する
|
|
114
|
+
|
|
115
|
+
with open('TrendJapan.csv', 'w') as csv_file:
|
|
116
|
+
|
|
117
|
+
csvwriter = csv.writer(csv_file, delimiter='\t')
|
|
118
|
+
|
|
119
|
+
for session in lista:
|
|
120
|
+
|
|
121
|
+
for item in lista[session]:
|
|
122
|
+
|
|
123
|
+
csvwriter.writerow([session, item, lista[session][item].columns[0], lista[session][item].columns[1]])
|
|
124
|
+
|
|
125
|
+
lista[session][item].to_csv(csv_file, mode='a', header=False)
|
|
126
|
+
|
|
127
|
+
|
|
128
|
+
|
|
129
|
+
```
|