±»²ÙÈí¼þʹÓÃÏê½â¼°³£¼ûÎÊÌâÅŲé

À´Ô´£ºÖ¤È¯Ê±±¨Íø×÷Õߣº
×ÖºÅ

±àд´úÂë»ò½Å±¾

±àд´úÂë»ò½Å±¾ÊDZ»²ÙÈí¼þµÄ½¹µã¡£²î±ðµÄÈí¼þʹÓòî±ðµÄ±à³ÌÓïÑÔ»ò½Å±¾ÓïÑÔ¡£ÀýÈç £¬ExcelºêʹÓÃVBA£¨VisualBasicforApplications£©±à³ÌÓïÑÔ £¬Python½Å±¾Ê¹ÓÃPythonÓïÑÔ £¬SPSSÔòʹÓÃÆä×ÔÓÐÃüÁîÓïÑÔ¡£ÔÚ±àд´úÂëʱ £¬ÐèҪƾ¾Ý¾ßÌåµÄÈÎÎñÐèÇó £¬±àд³öÄܹ»ÊµÏÖËùÐ蹦ЧµÄ´úÂë¡£

×Ô½ç˵¹¦Ð§¿ª·¢

¹ØÓÚÐèÒª¸ß¼¶¹¦Ð§µÄÓû§ £¬¿ÉÒÔͨ¹ý×Ô½ç˵¹¦Ð§¿ª·¢À´À©Õ¹±»²ÙÈí¼þµÄÄÜÁ¦¡£Õâͨ³£ÐèÒª¾ß±¸Ò»¶¨µÄ±à³Ì¼¼ÊõºÍ¶ÔÈí¼þÄÚ²¿»úÖÆµÄÁ˽â¡£¿ÉÒÔͨ¹ýÒÔÏÂÒªÁìʵÏÖ×Ô½ç˵¹¦Ð§¿ª·¢£º

À©Õ¹API£ºÍ¨¹ýÀ©Õ¹Èí¼þµÄAPI £¬ÊµÏÖ¶Ôй¦Ð§µÄŲÓúͿØÖÆ¡£±àд²å¼þ£ºÐí¶à±»²ÙÈí¼þÖ§³Ö²å¼þ»úÖÆ £¬Óû§¿ÉÒÔ±àд²å¼þÀ´Ôö¼ÓÐµĹ¦Ð§¡£ÐÞ¸ÄÔ´´úÂ룺¹ØÓÚ¿ªÔ´Èí¼þ £¬Óû§¿ÉÒÔÐÞ¸ÄÔ´´úÂë £¬Ìí¼ÓÐµĹ¦Ð§ºÍÓÅ»¯¡£

¼¯³ÉÆäËû¹¤¾ß

±»²ÙÈí¼þ¿ÉÒÔÓëÆäËû¹¤¾ß½øÐм¯³É £¬ÒÔʵÏÖ¸ü¸ßЧµÄÊÂÇéÁ÷³Ì¡£³£¼ûµÄ¼¯³É·½·¨°üÀ¨£º

ÓëÊý¾Ý¿â¼¯³É£ºÍ¨¹ýÊý¾Ý¿âAPI £¬ÊµÏÖÊý¾ÝµÄ×Ô¶¯»¯´¦ÀíºÍ´æ´¢¡£ÓëÆäËû×Ô¶¯»¯¹¤¾ß¼¯³É£ºÈçSelenium¡¢JenkinsµÈ £¬ÊµÏֶ๤¾ßÁª¶¯ £¬Ìá¸ßÊÂÇéЧÂÊ¡£ÓëÔÆÐ§Àͼ¯³É£ºÍ¨¹ýÔÆÐ§ÀÍAPI £¬ÊµÏÖÔÆ¶Ë×ÊÔ´µÄ×Ô¶¯»¯ÖÎÀíºÍµ÷Àí¡£

ʹÓð취£º

×°ÖÃPython£º´ÓPython¹ÙÍøÏÂÔØ²¢×°ÖÃPython½âÊÍÆ÷¡£×°Öÿ⣺ʹÓÃpip×°ÖÃËùÐè¿â £¬Èçpipinstallpandasnumpymatplotlib¡£±àд½Å±¾£ºÔÚÎı¾±à¼­Æ÷£¨ÈçVSCode¡¢SublimeText£©ÖбàдPython´úÂë £¬Éú´æ²¢ÔÚÃüÁîÐÐÖÐÔËÐС£

ʹÓð취£º

ÆôÓú깦Ч£ºÔÚExcelÖÐ £¬½øÈë¡°Îļþ¡±->¡°Ñ¡Ï->¡°ÐÅÈÎÖÐÐÄ¡±->¡°ÐÅÈÎÖÐÐÄÉèÖá± £¬È·±£ÆôÓú깦Ч¡£Â¼Öƺ꣺ÔÚ¡°¿ª·¢¹¤¾ß¡±Ñ¡ÏÖÐ £¬µã»÷¡°Â¼Öƺꡱ £¬½øÐвÙ×÷ºóµã»÷¡°Í£Ö¹Â¼ÖÆ¡± £¬Excel»á×Ô¶¯Éú³É¶ÔÓ¦µÄVBA´úÂë¡£±àдVBA´úÂ룺ÔÚ¡°¿ª·¢¹¤¾ß¡±Ñ¡ÏÖÐ £¬µã»÷¡°VisualBasic¡± £¬¿ÉÒÔÊÖ¶¯±àд»òÐÞ¸ÄVBA´úÂë¡£

У¶Ô£º°×ÑÒËÉ(1C0m4pJyqZtPma0S7t9ZFfz4hTykKag)

ÔðÈα༭£º ¹ùÕýÁÁ
ΪÄãÍÆ¼ö
Óû§ÆÀÂÛ
µÇ¼ºó¿ÉÒÔ̸»°
ÍøÓÑÆÀÂÛ½ö¹©Æä±í´ï¸öÈË¿´·¨ £¬²¢²»±êÃ÷֤ȯʱ±¨Á¢³¡
ÔÝÎÞÆÀÂÛ