_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPageTools/url › DataFrameSQL襦る蠍

Contents

1 覦覯1: [https]pysqldf 殊企襴
2 覦覯2: [https]pandasql 殊企襴


覦覯1 . 蠏碁磯.. 覘螳 . 覦覯2襦 .

1 覦覯1: [https]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;")

2 覦覯2: [https]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
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

覿 譟伎手 螳 讌 覿伎 讌螳 . 譯 殊 蠍一 朱 蟆 蠏 企 覿 レ ろ 覯襴螻 襷. 蠏碁 譯 殊 蠍一 蟆曙 企ゴ蠍郁讌 伎姶 螳讌 覿 螳危讌 螳 . 覿企 螻 覲企 覲旧企朱 企 覓 覦 襴讌 覲給 蠍一 覓願係 螳 蟆企. (伎語 "襴 語 蟇企蠍" 筝)