Just For My Daily Diary
Just For My Daily Diary
This notebook is an exercise in the Data Cleaning course. You can reference the tutorial at this link. In this exercise, you’ll apply what you learned in the Scaling and normalization tutorial. 在本练习中，您将应用在缩放和规范化教程中学到的知识。 Setup 设置 The questions below will give you feedback on your work. Run the following cell to set up the feedback system. […]
In this notebook, we’re going to be looking at how to scale and normalize data (and what the difference is between the two!). 在本笔记本中，我们将研究如何缩放和标准化数据（以及两者之间的区别！）。 Let’s get started! 让我们开始吧！ Get our environment set up 设置我们的环境 The first thing we’ll need to do is load in the libraries we’ll be using. 我们需要做的第一件事是加载我们将使用的库。 # modules we'll use import […]
This notebook is an exercise in the Data Cleaning course. You can reference the tutorial at this link. In this exercise, you’ll apply what you learned in the Handling missing values tutorial. 在本练习中，您将应用在处理缺失值教程中学到的知识。 Setup 设置 The questions below will give you feedback on your work. Run the following cell to set up the feedback system. […]
Welcome to the Data Cleaning course on Kaggle Learn! 欢迎来到 Kaggle Learn 上的数据清理课程！ Data cleaning is a key part of data science, but it can be deeply frustrating. Why are some of your text fields garbled? What should you do about those missing values? Why aren’t your dates formatted correctly? How can you quickly clean […]
This notebook is an exercise in the SQL course. You can reference the tutorial at this link. Introduction 介绍 Stack Overflow is a widely beloved question and answer site for technical questions. You’ll probably use it yourself as you keep using SQL (or any programming language). Stack Overflow 是一个广受欢迎的技术问题问答网站。 当您继续使用 SQL（或任何编程语言）时，您可能会使用它。 Their data is publicly […]
Introduction 介绍 You have the tools to obtain data from a single table in whatever format you want it. But what if the data you want is spread across multiple tables? 您可以使用工具以您想要的任何格式从单个表中获取数据。 但是，如果您想要的数据分布在多个表中怎么办？ That’s where JOIN comes in! JOIN is incredibly important in practical SQL workflows. So let’s get started. 这就是 JOIN 发挥作用的地方！ JOIN 在实际 […]
This notebook is an exercise in the SQL course. You can reference the tutorial at this link. import pandas as pd Introduction 介绍 You are getting to the point where you can own an analysis from beginning to end. So you’ll do more data exploration in this exercise than you’ve done before. Before you get […]
Introduction 介绍 With all that you’ve learned, your SQL queries are getting pretty long, which can make them hard understand (and debug). 根据您所学的知识，您的 SQL 查询变得相当长，这可能使它们难以理解（和调试）。 You are about to learn how to use AS and WITH to tidy up your queries and make them easier to read. 您将学习如何使用 AS 和 WITH 来整理您的查询并使它们更易于阅读。 Along the way, […]
This notebook is an exercise in the SQL course. You can reference the tutorial at this link. Introduction 介绍 You’ve built up your SQL skills enough that the remaining hands-on exercises will use different datasets than you see in the explanations. If you need to get to know a new dataset, you can run a […]
Introduction 介绍 So far, you’ve learned how to use several SQL clauses. For instance, you know how to use SELECT to pull specific columns from a table, along with WHERE to pull rows that meet specified criteria. You also know how to use aggregate functions like COUNT(), along with GROUP BY to treat multiple rows […]