<![CDATA[
<p><span style="color: #9cdcfe;">driver</span> <span style="color: #d4d4d4;">=</span> <span style="color: #4ec9b0;">webdriver</span><span style="color: #cccccc;">.</span><span style="color: #4ec9b0;">Chrome</span><span style="color: #cccccc;">()</span></p><p> </p><p><span style="color: #9cdcfe;">url</span> <span style="color: #d4d4d4;">=</span><span style="color: #ce9178;">"<a href="https://www.genie.co.kr/chart/top200" target="_top" class="ke-link">https://www.genie.co.kr/chart/top200</a>"</span></p><p><span style="color: #9cdcfe;">driver</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">get</span><span style="color: #cccccc;">(</span><span style="color: #9cdcfe;">url</span><span style="color: #cccccc;">)</span></p><p> </p><p><span style="color: #9cdcfe;">html</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">driver</span><span style="color: #cccccc;">.</span><span style="color: #9cdcfe;">page_source</span></p><p><span style="color: #9cdcfe;">soup</span> <span style="color: #d4d4d4;">=</span> <span style="color: #4ec9b0;">BeautifulSoup</span><span style="color: #cccccc;">(</span><span style="color: #9cdcfe;">html</span><span style="color: #cccccc;">,</span><span style="color: #ce9178;">'html.parser'</span><span style="color: #cccccc;">)</span></p><p> </p><p><span style="color: #9cdcfe;">songs</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">soup</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"table>tbody>tr"</span><span style="color: #cccccc;">)</span></p><p><span style="color: #dcdcaa;">len</span><span style="color: #cccccc;">(</span><span style="color: #9cdcfe;">songs</span><span style="color: #cccccc;">)</span></p><p><span style="color: #9cdcfe;">song</span> <span style="color: #d4d4d4;">=</span><span style="color: #9cdcfe;">songs</span><span style="color: #cccccc;">[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">]</span></p><p><span style="color: #9cdcfe;">song</span></p><p> </p><p><span style="color: #9cdcfe;">title</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"td.info > a"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span><span style="color: #cccccc;">.strip()</span></p><p><span style="color: #9cdcfe;">singer</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"td.info > a"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">1</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span></p><p><span style="color: #9cdcfe;">rank</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">".number"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span><span style="color: #cccccc;">.split(</span><span style="color: #ce9178;">'</span><span style="color: #d7ba7d;">\n</span><span style="color: #ce9178;">'</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">]</span></p><p><span style="color: #9cdcfe;">rank</span></p><p><span style="color: #9cdcfe;">album</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"td.info > a"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">2</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span></p><p><span style="color: #9cdcfe;">album</span></p><p> </p><p><span style="color: #9cdcfe;">song_datas</span> <span style="color: #d4d4d4;">=</span><span style="color: #cccccc;"> []</span></p><p><span style="color: #c586c0;">for</span> <span style="color: #9cdcfe;">song</span> <span style="color: #c586c0;">in</span> <span style="color: #9cdcfe;">songs</span><span style="color: #cccccc;">:</span></p><p><span style="color: #cccccc;">    </span><span style="color: #9cdcfe;">title</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"td.info > a"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span><span style="color: #cccccc;">.strip()</span></p><p><span style="color: #cccccc;">    </span><span style="color: #9cdcfe;">singer</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"td.info > a"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">1</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span></p><p><span style="color: #cccccc;">    </span><span style="color: #9cdcfe;">rank</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">".number"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span><span style="color: #cccccc;">.split(</span><span style="color: #ce9178;">'</span><span style="color: #d7ba7d;">\n</span><span style="color: #ce9178;">'</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">0</span><span style="color: #cccccc;">]</span></p><p><span style="color: #cccccc;">    </span><span style="color: #9cdcfe;">album</span> <span style="color: #d4d4d4;">=</span> <span style="color: #9cdcfe;">song</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">select</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">"td.info > a"</span><span style="color: #cccccc;">)[</span><span style="color: #b5cea8;">2</span><span style="color: #cccccc;">].</span><span style="color: #9cdcfe;">text</span></p><p><span style="color: #cccccc;">    </span><span style="color: #9cdcfe;">song_datas</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">append</span><span style="color: #cccccc;">([</span><span style="color: #ce9178;">"gini"</span><span style="color: #cccccc;">,</span><span style="color: #9cdcfe;">title</span><span style="color: #cccccc;">,</span><span style="color: #9cdcfe;">singer</span><span style="color: #cccccc;">,</span><span style="color: #9cdcfe;">album</span><span style="color: #cccccc;">,</span><span style="color: #569cd6;">f</span><span style="color: #ce9178;">'</span><span style="color: #569cd6;">{</span><span style="color: #9cdcfe;">rank</span><span style="color: #569cd6;">}</span><span style="color: #ce9178;">위'</span><span style="color: #cccccc;">])</span></p><p> </p><p><span style="color: #9cdcfe;">song_datas</span></p><p> </p><p><span style="color: #9cdcfe;">columes</span> <span style="color: #d4d4d4;">=</span><span style="color: #cccccc;"> [</span><span style="color: #ce9178;">'서비스'</span><span style="color: #cccccc;">,</span><span style="color: #ce9178;">'타이틀'</span><span style="color: #cccccc;">,</span><span style="color: #ce9178;">'가수'</span><span style="color: #cccccc;">,</span><span style="color: #ce9178;">'순위'</span><span style="color: #cccccc;">]</span></p><p><span style="color: #9cdcfe;">data_f</span> <span style="color: #d4d4d4;">=</span> <span style="color: #4ec9b0;">pd</span><span style="color: #cccccc;">.</span><span style="color: #4ec9b0;">DataFrame</span><span style="color: #cccccc;">(</span><span style="color: #9cdcfe;">song_datas</span><span style="color: #cccccc;">,</span><span style="color: #9cdcfe;">columns</span><span style="color: #d4d4d4;">=</span><span style="color: #9cdcfe;">columes</span><span style="color: #cccccc;">)</span></p><p><span style="color: #9cdcfe;">data_f</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">head</span><span style="color: #cccccc;">()</span></p><p> </p><p><span style="color: #9cdcfe;">data_f</span><span style="color: #cccccc;">.</span><span style="color: #dcdcaa;">to_excel</span><span style="color: #cccccc;">(</span><span style="color: #ce9178;">'gini.xlsx'</span><span style="color: #cccccc;">,</span><span style="color: #9cdcfe;">index</span><span style="color: #d4d4d4;">=</span><span style="color: #569cd6;">False</span><span style="color: #cccccc;">)</span></p>
<!-- -->
]]>
카페 게시글
우리들의 이야기
gini_study
유성준
추천 0
조회 4
25.03.27 17:48
댓글 0
다음검색
