楼主: oliyiyi
3694 16

Pandasql: Make python speak SQL [推广有奖]

版主

已卖:2993份资源

泰斗

1%

还不是VIP/贵宾

-

TA的文库  其他...

计量文库

威望
7
论坛币
117070 个
通用积分
31670.9540
学术水平
1454 点
热心指数
1573 点
信用等级
1364 点
经验
384134 点
帖子
9629
精华
66
在线时间
5508 小时
注册时间
2007-5-21
最后登录
2025-7-8

初级学术勋章 初级热心勋章 初级信用勋章 中级信用勋章 中级学术勋章 中级热心勋章 高级热心勋章 高级学术勋章 高级信用勋章 特级热心勋章 特级学术勋章 特级信用勋章

楼主
oliyiyi 发表于 2017-2-11 08:09:35 |AI写论文

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币

本帖隐藏的内容

This article was written by Yhat.

[color=rgb(255, 255, 255) !important]


Introduction

One of my favorite things about Python is that users get the benefit of observing the R community and then emulating the best parts of it. I'm a big believer that a language is only as helpful as its libraries and tools.

This post is about pandasql, a Python package we (Yhat) wrote that emulates the R package sqldf. It's a small but mighty library comprised of just 358 lines of code. The idea of pandasqlis to make Python speak SQL. For those of you who come from a SQL-first background or still "think in SQL", pandasql is a nice way to take advantage of the strengths of both languages.

In this introduction, we'll show you to get up and running with pandasql inside of Rodeo, the integrated development environment (IDE) we built for data exploration and analysis. Rodeo is an open source and completely free tool. If you're an R user, its a comparable tool with a similar feel to RStudio. As of today, Rodeo can only run Python code, but last week we addedsyntax highlighting for a bunch of other languages to the editor (markdown, JSON, julia, SQL, markdown). As you may have read or guessed, we've got big plans for Rodeo, including adding SQL support so that you can run your SQL queries right inside of Rodeo, even without our handy little pandasql. More on that in the next week or two!

What you will find in this article:

  • Downloading Rodeo
  • A bit of background, if you're curious
  • Install pandasql
  • Check out the datasets
  • An odd graph
  • It's just SQL
  • Final thoughts

To check out all this information, click here.



二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:python pandas speak panda make python

已有 2 人评分经验 论坛币 学术水平 热心指数 信用等级 收起 理由
janyiyi + 5 + 3 + 3 + 3 精彩帖子
Nicolle + 100 精彩帖子

总评分: 经验 + 100  论坛币 + 5  学术水平 + 3  热心指数 + 3  信用等级 + 3   查看全部评分

本帖被以下文库推荐

缺少币币的网友请访问有奖回帖集合
https://bbs.pinggu.org/thread-3990750-1-1.html

沙发
meijiemeijie 发表于 2017-2-11 08:54:43
我们看看

藤椅
ekscheng 发表于 2017-2-11 17:35:46

板凳
wilfafkt 发表于 2017-2-11 22:30:40
看看看

报纸
bearfighting 发表于 2017-2-12 11:49:40
什么好书啊

地板
sareta 发表于 2017-2-12 18:52:36
kkkkkkkkk

7
hanilichina 发表于 2017-2-12 22:40:08
duoxie               

8
franky_sas 发表于 2017-2-13 10:45:54

9
mike68097 发表于 2017-2-13 11:47:29

10
kkkm_db 发表于 2017-2-20 00:39:07
kankan

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注jltj
拉您入交流群
GMT+8, 2025-12-9 12:44