_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › DataFrameSQL襦る蠍
|
|
覦覯1 . 蠏碁磯.. 覘螳 . 覦覯2襦 .
[edit]
1 覦覯1: pysqldf 殊企襴 #from pysqldf import SQLDF import pandas as pd import io txt = io.StringIO(""" col1 col2 a 1 b 2 c 3 d 4 """) df = pd.read_csv(txt, sep="\t") df sqldf = SQLDF(globals()) sqldf.execute("select * from df limit 3;") [edit]
2 覦覯2: pandasql 殊企襴 #from pandasql import sqldf import pandas as pd import io txt = io.StringIO(""" col1 col2 a 1 b 2 c 3 d 4 """) df = pd.read_csv(txt, sep="\t") df pysqldf = lambda q: sqldf(q, globals()) df2 = pysqldf("select * from df limit 3;") df2
鏤
|
伎觜螳 企Μ螻 . 轟 覦 螳 一一 ク. 蠏瑚朱 豢覿.蟲讌蟲讌蟆 觜螳 る蟲! 企 襷 覓伎 螳. 觜 蟲襴 覦 蟆一 襷襦 讌 伎Ц 觜 覯 る所 企Μ蟲謂螻 襷讌 覈詩螳. <<襷 覲牛伎 255螳讌 伎手鍵>> () |