| Data Analysis(R) |
| Data Analysis(Python) |
| Statistics |
| Data Warehouse |
| Database System |
| SQL Server |
| Hive |
| Hadoop |
| Regular Expressions |
| Tools |
| Working Smart |
| Blog |
| Booklog |
| Philosophy |
| Link |
| Miscellaneous |
| __ edit |
覦覯1 . 蠏碁磯.. 覘螳 . 覦覯2襦 .
[edit]
1 覦覯1: ![[https]](/moniwiki/imgs/https.png)
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
鏤