ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[­ì³Ð] python¤W¥«Âd¤T¤jªk¤H¶R½æ¶W¤é³ø¸ê®Æ¤U¸ü

¦^´_ 30# c_c_lai
https://www.python.org/downloads/
3.xª©ªºÀ³¸Ó³£¤j¦P¤p²§¡A±z¦A¸Õ¸Õ¡C

TOP

¦^´_ 31# zyzzyva
ÁÂÁ§A¡A¤U¸ü¤F 3.4.5 ¸Õ¸Õ¡C

TOP

¦^´_ 20# zyzzyva

·PÁ±zªº¦^µª~
§Ú¥¿¤@¨B¤@¨B¶}©l¾Ç^^
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

§Ú¤§«e¬Ý¹L ¦³¤H¦b±ÀP»y¨¥
³Ìªñ¤~¨Ó³o­Ó½×¾Â
¬Ý¨ì§A­Ì°Q½×ªº«Ü¼ö¯P
®`§Ú¤]¶]¥h¤U¸ü¤FPython

§Ú¥Ø«e¦³¤@­Ó°µªk·Q¥Î EXCEL¤U¸ü  ªk¤H¸ê®Æ
¦ý¬O¬Ý¨ì¤j¤j¶K¥X³o­Ó»y¨¥ªº¤U¸ü
¬O§_·|¤ñ¸û²³æ¥i¦æ©O¡H
ÁÙ¬O¡A¨ä¹ê®t¤£¦h¡H

¦]¬°¥Ø«eÁÙ¨S¦³¯u¹ê¾Þ§@¹L[¤U¸ü¸ê®Æ]¸ò[¾ã²z¸ê®Æ]¸ò[§R°£­«½Æ¸ê®Æ]
¤£ª¾¹D¤j¤j¦b³o¤è­±¦³¨S¦³¤°»ò«Øij¡A¥i¥H«Øij§Ú
¸Ó«ç¼Ë°õ¦æ¤ñ¸û¬yºZ¡H
¬yµ{®Ú¨ãÅé¤j·§¬O«ç¼Ë
§Æ±æ¦³¤j¤j¥i¥H¦^µª§Ú
Åý§Ú¦³¤@­Óµ·¸ô....

TOP

¦^´_ 34# moco5360
À³¸Ó­n¬Ý§Aªº»Ý¨D¡G¬Ý§A­n¤U¸üªº¬O¤°»ò¼Ëªº¸ê®Æ¡A°µ¤°»ò¼Ëªº¾ã²z¡A(§R°£­«½Æ¸ê®Æ¤£¤ÓÀ´¡A¬O«ü¦pªG­«½Æ¤U¸ü­n§â¦hªº§R±¼ÁÙ¬O­ì¨Óªº¸ê®Æ´N¦³­«½Æ¡H)
vba§ì¸ê®Æ§Ú¤£¤Ó¼ô¡A¨S¿ìªk°µ¤ñ¸û¡A¤£¹Lpython¦b¤U¸ü¸ê®Æ¨Ó»¡¡A§Ú¦Û¤v¥Î°_¨Ó¬Oı±oÁÙº¡¶¶¤âªº¡C
¦pªG¸ê®Æ¶q¤£¦h¡A´N¥Îpython§â¸ê®Æ§ì¤U¨Ó¡A¦A¥Îexcel³B²z¡A¦pªG¸ê®Æ¦hªº¸Ü¡A¥i¯àÁÙ¬O­n©ñ¨ì¸ê®Æ®w¸Ì¤ñ¸û¦n¡C

TOP

¦^´_ 35# zyzzyva
¨ä¹ê¾Ç²ß¥ô¦óµ{¦¡»y¨¥§¡¦³¤@³q¯f¡A
¦b¾Ç²ß¹Lµ{¤¤¤j®a³£¤F¸Ñ¦U­Ó»yªkªº¨Ï¥Î¡A
¦ý­n±N¥¦­Ì°Â¦b¤@°_À³¥Î©ó¹ê°È­±®É¡A«o©¹©¹¤S¬O¥t¤@¦^¨Æ¡C
¦³¨Ç¤H¦]¦Ó©Ä¨B¤£«e¡A¬Æ¦Ü±ó¤§Â÷¥h¡C
Æ[¹î¨ä­ì¦]¦h¦]µL¹ê¥Îªº½d¨Ò±Ð¾Ç¤Þ¾É¡A¥R¤À¤§¸ê°T´£¨Ñ¡C
¦n¤ñ§Ú¾Ç²ß Excel VBA ¤@¶}©l§Ú¥u¬O¾ÌÂǵۦ³¨ä¥¦µ{¦¡»y¨¥­I´º
¼¶¼g°ò¦¡A¶i¦Ó±q¦U¦ì¤j¤jªº´£°Ý¤¤¤@¨B¤@¨B¦a±´°Q¡BÀ³¥Îªº¡C
¦pªG¤j¤j¯à´£¦C¤@¨Ç¹ê¥Î½d¨Ò¡B»Ý­n®M¥ó¡AÀ³¯d·N¨Æ¶µµ¥¡A
À°§U¤j®a´£¤É»â°ì¨º¤]¬O¥\¼w¤@¥ó°Ú¡I

TOP

¦^´_ 36# c_c_lai
¨ä¹ê§Ú¤]³£¥u¬O°µÂ²³æªºÀ³¥Î¡A¤@­Ó²³æªº¨Ò¤l(§ì¨ú´Á³f¥~¸ê¥æ©ö¤f¼Æ¥H°µ¬°¥æ©öµ¦²¤ªº°Ñ¦Ò)¡G
ºô§}¡Ghttp://www.taifex.com.tw/chinese/3/7_12_3.asp
°²³]¥Ø¼Ð¬O§ì¨ú¹Ï¤¤¬õ°éªº¼Æ¦r¡G
Screenshot_1.png
2016-9-7 12:27

©T©wªº°_¤â¦¡¤j·§´N¹³³o¼Ë(bs4­n¥t¥~¦w¸Ë¡AÁÙ¦³¤@­Ó¤]«Ü¦n¥Îªº¬Olxml)¡G
  1. import requests
  2. from bs4 import BeautifulSoup

  3. url = 'http://www.taifex.com.tw/chinese/3/7_12_3.asp'

  4. res = requests.get(url)

  5. soup = BeautifulSoup(res.text)

  6. tbl = soup.select('.table_f td')

  7. print(tbl[33].text)
½Æ»s¥N½X
¦]¬°¨Ï¥Î¤Frequests©Mbs4¡A¥u­n²µuªº´X¦æµ{¦¡½X´N¥i¥H¹F¨ì§Ú­Ìªº»Ý¨D¡C

TOP

¦^´_ 37# zyzzyva
E5.png
2016-9-7 15:10

TOP

¦^´_ 38# c_c_lai


    soup = BeautifulSoup(res.text,"html.parser")

TOP

¦^´_ 38# c_c_lai
¨º­Ó°T®§¤£¼vÅT°õ¦æ¡A¦pªG¤£·Q¬Ý¨ìĵ§i°T®§¥u­n¹³L¤j»¡ªº«ü©wparser´N¥i¥H¤F¡C§âsoup¨º¬q§ï¦¨
soup = BeautifulSoup(res.text, "html. parser")

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD