sql汇总子级数据汇总_用SQL汇总数据

sql汇总子级数据汇总

About Matt: Matt DeLand is Co-Founder and Data Scientist at Wagon. His team is building a collaborative SQL editor for analysts and engineers. He studied algebraic geometry at Columbia University, taught at the University of Michigan, and now enjoys applied machine learning— his mom is very proud!

关于Matt： Matt DeLand是Wagon的联合创始人兼数据科学家。 他的团队正在为分析师和工程师构建协作SQL编辑器。 他在哥伦比亚大学学习了代数几何，在密歇根大学任教，现在喜欢应用机器学习-他的妈妈感到非常自豪！

介绍 (Introduction)

How quickly can you understand data from your database? Excel croaks at ten thousands rows, R is difficult to run on a cluster, and your eye certainly can’t summarize large tables. SQL to the rescue!

您能多快地从数据库中了解数据？ Excel崩溃了1万行，R很难在群集上运行，并且您的眼睛当然无法汇总大表。 SQL来解救！

Summary statistics are the fastest way to learning about your dataset. Are there outliers? How does the distribution look? What are the relationships hiding inside the rows and columns? You’ll always want to ask these questions when faced with a new dataset. SQL (an uninspired acronym for Structured Query Language) is the native language for database computation. Many summary methods are available as built in SQL functions in modern databases and more complex measures can be implemented directly in SQL as well.

摘要统计信息是了解数据集的最快方法。 有离群值吗？ 分布看起来如何？ 隐藏在行和列内的关系是什么？ 面对新的数据集时，您总是想问这些问题。 SQL（结构化查询语言的缩写）是数据库计算的本地语言。 现代数据库中SQL函数内置了许多汇总方法，并且更复杂的方法也可以直接在SQL中实现。

In this post, we’ll walk through 4 ways to summarize your dataset in SQL so you can run it directly on your database.

在本文中，我们将通过4种方式总结SQL中的数据集，以便您可以直接在数据库上运行它。

总结摘要 (A summary of summaries)

1. The Basics
2. Percentiles
3. Histogram
4. Joint Distributions

1. 基础
2. 百分位数
3. 直方图
4. 联合发行

Here’s a relatable example: suppose we work in a banana stand’s back office and we analyze banana data.

这是一个相关的示例&