用pandas实现sql功能

最新推荐文章于 2024-08-03 15:50:30 发布

ZenGeek

最新推荐文章于 2024-08-03 15:50:30 发布

阅读量3.3k

点赞数 8

分类专栏：数据库 python包文章标签： pandas sql

本文链接：https://blog.csdn.net/zeng_xiangt/article/details/81519535

版权

本文介绍了如何利用pandas库来实现SQL查询的功能，详细探讨了如何将SQL查询语句转换为pandas的数据操作。

摘要由CSDN通过智能技术生成

                    
   SQL
   Pandas
  
   select * from airports
   airports
  
   select * from airports limit 3
   airports.head(3)
  
   select id from airports where ident = ‘KLAX’
   airports[airports.ident == ‘KLAX’].id
  
   select distinct type from airport
   airports.type.unique()
  
   SQL
   Pandas
  
   select * from airports where iso_region = ‘US-CA’ and type = ‘seaplane_base’
   airports[(airports.iso_region == ‘US-CA’) & (airports.type == ‘seaplane_base’)]
  
   select ident, name, municipality from airports where iso_region = ‘US-CA’ and type = ‘large_airport’
   airports[(airports.iso_region == ‘US-CA’) & (airports.type == ‘large_airport’)][[‘ident’, ‘name’, ‘municipality’]]
  
   SQL
   Pandas
  
   select * from airport_freq where airport_ident = ‘KLAX’ order by type
   airport_freq[airport_freq.airport_ident == ‘KLAX’].sort_values(‘type’)

SQL	Pandas
select * from airports	airports
select * from airports limit 3	airports.head(3)
select id from airports where ident = ‘KLAX’	airports[airports.ident == ‘KLAX’].id
select distinct type from airport	airports.type.unique()

SQL	Pandas
select * from airports where iso_region = ‘US-CA’ and type = ‘seaplane_base’	airports[(airports.iso_region == ‘US-CA’) & (airports.type == ‘seaplane_base’)]
select ident, name, municipality from airports where iso_region = ‘US-CA’ and type = ‘large_airport’	airports[(airports.iso_region == ‘US-CA’) & (airports.type == ‘large_airport’)][[‘ident’, ‘name’, ‘municipality’]]

SQL	Pandas
select * from airport_freq where airport_ident = ‘KLAX’ order by type	airport_freq[airport_freq.airport_ident == ‘KLAX’].sort_values(‘type’)