Python¾ØÕóתÖÃÖеĶþάÊý×éµÄʵ¼Ê²Ù×÷·½°¸½éÉÜ
Èç¹ûÄã¶ÔPython¾ØÕóתÖõÄʵ¼ÊÓ¦ÓòÙ×÷·½°¸µÄתÖò»ÖªµÀÈçºÎ½øÐÐÏÂÒ»²½Ê±£¬Äã¾ÍÄãÐèҪתÖÃÒ»¸ö¶þάÊý×é,½«Python¾ØÕóתÖõÄÐÐÁл¥»».
ÕâÑù¾Í¿ÉÒÔÍê³ÉÄãËùÐèÒªµÄÓ¦ÓòÙ×÷£¬ÒÔÏÂÊÇÎÄÕµľßÌå²Ù×÷¡£
ÄãÐèҪתÖÃÒ»¸ö¶þάÊý×é,½«ÐÐÁл¥»»£¬ÌÖÂÛ:ÄãÐèҪȷ±£¸ÃÊý×éµÄÐÐÁÐÊý¶¼ÊÇÏàͬµÄ.±ÈÈç:
arr
= [[1, 2, 3], [4, 5, 6], [7, 8, 9], [10, 11, 12]]
ÁбíµÝÍÆÊ½ÌṩÁËÒ»¸ö¼ò±ãµÄ¾ØÕóתÖõķ½·¨:
print [[r[col] for r in arr] for col in range(len(arr[0]))]
[[1, 4, 7, 10], [2, 5, 8, 11], [3, 6, 9, 12]]
ÁíÒ»¸ö¸ü¿ìºÍ¸ß¼¶Ò»Ð©µÄ·½·¨,¿ÉÒÔʹÓÃzipº¯Êý:
print map(list, zip(*arr))
±¾½ÚÌṩÁ˹ØÓÚ¾ØÕóתÖõÄÁ½¸ö·½·¨,Ò»¸ö±È½ÏÇåÎú¼òµ¥,ÁíÒ»¸ö±È½Ï¿ìËÙµ«ÓÐЩÒþ»Þ.ÓÐʱºò,Êý¾Ýµ½À´µÄʱºòʹÓôíÎóµÄ·½Ê½,±ÈÈç,ÄãʹÓÃ΢ÈíµÄ
ADO½Ó¿Ú·ÃÎÊÊý¾Ý¿â,ÓÉÓÚPython¾ØÕóתÖÃ
ºÍMSÔÚÓïÑÔʵÏÖÉϵIJî±ð.
Getrows·½·¨ÔÚPythonÖпÉÄÜ·µ»ØµÄÊÇÁÐÖµ,ºÍ·½·¨µÄÃû³Æ²»Í¬.±¾½Ú¸øµÄ³öµÄ·½·¨¾ÍÊÇÕâ¸öÎÊÌâ³£¼ûµÄ½â¾ö·½°¸,Ò»¸ö¸üÇåÎú,Ò»¸ö¸ü¿ìËÙ.
ÔÚÁбíµÝÍÆÊ½°æ±¾ÖÐ,ÄÚ²ãµÝÍÆÊ½±íʾѡÔòʲô(ÐÐ),Íâ²ãµÝÍÆÊ½±íʾѡÔñÕß(ÁÐ).Õâ¸ö¹ý³ÌÍê³Éºó¾ÍʵÏÖÁËתÖÃ.
ÔÚzip°æ±¾ÖÐ,ÎÒÃÇʹÓÃ*arrÓï·¨½«Ò»Î¬Êý×é´«µÝ¸øzip×öΪ²ÎÊý,½Ó×Å,zip·µ»ØÒ»¸öÔª×é×öΪ½á¹û.È»ºóÎÒÃǶÔÿһ¸öÔª×éʹÓÃlist·½
·¨,²úÉúÁËÁбíµÄÁбí(¼´¾ØÕó).ÒòΪÎÒÃÇûÓÐÖ±½Ó½«zipµÄ½á¹û±íʾΪlist,
ËùÒÔÎÒÃÇ¿ÉÒÔÎÒÃÇ¿ÉÒÔʹÓÃitertools.izipÀ´ÉÔ΢µÄÌá¸ßЧÂÊ(ÒòΪizip²¢Ã»Óн«Êý¾ÝÔÚÄÚ´æÖÐ×é֯ΪÁбí).
import itertools
print map(list, itertools.izip(*arr))
µ«ÊÇ,ÔÚÌØ¶¨µÄÇé¿öÏÂ,ÉÏÃæµÄ·½·¨¶ÔЧÂʵÄ΢ÈõÌáÉý²»ÄÜÃÖ²¹¶Ô¸´ÔӶȵÄÔö¼Ó.¹ØÓÚ*argsºÍ**kwdsÓï·¨:*args(ʵ¼ÊÉÏ,*ºÅºóÃæ¸ú×Å
±äÁ¿Ãû)Óï·¨ÔÚPythonÖбíʾ´«µÝÈÎÒâµÄλÖñäÁ¿,µ±ÄãʹÓÃÕâ¸öÓï·¨µÄʱºò(±ÈÈç,ÄãÔÚ¶¨Ò庯ÊýʱʹÓÃ),Python½«Õâ¸ö±äÁ¿ºÍÒ»¸öÔª×é°ó¶¨,²¢
±£ÁôËùÓеÄλÖÃÐÅÏ¢, ¶ø²»ÊǾßÌåµÄ±äÁ¿.µ±ÄãʹÓÃÕâ¸ö·½·¨´«µÝ²ÎÊýʱ,±äÁ¿¿ÉÒÔÊÇÈÎÒâµÄ¿Éµü´ú¶ÔÏó(Æäʵ¿ÉÒÔÊÇÈκαí´ïʽ,Ö»Òª·µ»ØÖµÊǵü´úÆ÷).
**kwdsÓï·¨ÔÚPythonÖÐÓÃÓÚ½ÓÊÕÃüÃû²ÎÊý.µ±ÄãÓÃÕâ¸ö·½Ê½´«µÝ²ÎÊýʱ,Python½«±äÁ¿ºÍÒ»¸ödict°ó¶¨,±£
Ïà¹ØÎĵµ£º
È«ÎÄÀ´×Ô£ºIT¹¤³Ì¼¼ÊõÍø http://www.systhinker.com/html/91/n-11591.html
×òÌìºÍ·ÉÌìÎèÕßÌÖÂÛ¾²Ì¬ÀàÐÍÓïÑԺͶ¯Ì¬ÀàÐÍÓïÑÔÓÅÁӱȽϵÄʱºò£¬Ëµµ½PythonûÓÐÖØÔØ»úÖÆµÄÎÊÌâ¡£
ºóÀ´ÏëÏëͦÓÐÒâ˼µÄ£¬°Ñ˼¿¼µÄ¾¹ý¼Ç¼ÏÂÀ´£¬»¶ÓÅÄש¡£
ÖØÔØ£¨overload£©ºÍ¸²¸Ç£¨override£©£¬ÔÚC++£¬Java£¬C#µÈ¾²Ì¬ÀàÐÍÓïÑÔÀàÐÍÓïÑÔÖУ¬ÕâÁ½¸ö ......
£¨Ò»£© py2exe¼ò½é
py2exeÊÇÒ»¸ö½«python½Å±¾×ª»»³ÉwindowsÉϵĿɶÀÁ¢Ö´ÐеĿÉÖ´ÐгÌÐò(*.exe)µÄ¹¤¾ß£¬ÕâÑù£¬Äã¾Í¿ÉÒÔ²»ÓÃ×°python¶øÔÚ
windowsϵͳÉÏÔËÐÐÕâ¸ö¿ÉÖ´ÐгÌÐò¡£
¡¡¡¡
¡¡¡¡py2exeÒѾ±»ÓÃÓÚ´´½¨
wxPython,Tkinter,Pmw,PyGTK,pygame,win32com
clientºÍserver,ºÍÆäËüµÄ¶ÀÁ¢³ ......
PythonÓëMysql
Ò»¡¢°²×°MySQLdbÄ£¿é
ʹÓÃpythonÁ¬½ÓMysqlµÄǰÌᣬ¾ÍÊÇÐèÒªÒ»¸öÈÃpythonÁ¬½Óµ½MysqlµÄ½Ó¿Ú£¬Õâ¾ÍÊÇMySQLdbÄ£¿é¡£
ÑéÖ¤ÊÇ·ñÒѾ°²×°ÁËMySQLdb£º
==========================================================
d:\usr\local\Python25>python
Python 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v ......
ÉÏһƪÀïµÄLAMEÏîÄ¿ÒѾչʾÁËpythonÈçºÎÓëCÓïÑÔ½»»¥£¬µ«³ÌÐòÈÔ²»¹»ÀíÏ룬ÔÚpythonÕâÒ»¶Ë½ö½öÊÇ´«µÝÔ´ÎļþºÍÄ¿±êÎļþµÄ·¾¶£¬ÔÙµ÷ÓÃCÄ£¿éµÄencode·½·¨À´½øÐбàÂ룬µ«ÎÊÌâÔÚÓÚÄãÎÞ·¨¿ØÖÆencodeº¯Êý£¬±ÈÈçÄãÏë±àÂëµÄÔ´ÎļþÈç¹û²»ÊÇÔʼÊý¾Ý£¬¶øÊÇwavÎļþ»òÕ߯äËû¸ñÊ½ÄØ£¿¶ÔÓÚÕâ¸öÎÊÌ⣬ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÑ¡Ôñ£¬Ò»ÖÖÄ£·ÂÇ°ÃæµÄCÄ£ ......
>>> a="abcd"
>>> ",".join(a)
'a,b,c,d'
>>> "|".join(['a','b','c'])
'a|b|c'
>>> ",".join(('a','b','c'))
'a,b,c'
>>> ",".join({'a':1,'b':2,'c':3})
'a,c,b' ......