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

るジ 蟲郁 蠍語 覦 譯手鍵 焔 貅覃 蟆郁記 蠍碁 覦 蟆 . (覯 れ碁)