_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 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

蠍 襴 譴煙 襦 碁企 語誤 一襯 殊 . 襯 蠍一牛螻 企朱 る 襯 襦 螻褐 蟲磯磯企朱 る 蠏 襷れ 覲牛 蟾. 讌蠍 襴 朱覿 讌襷 蟆一 讌 襦 螳 蟆企. ()