Merge, Sort and Filter Data in Python Pandas

4.4
84 個評分
提供方
Coursera Project Network
2,933 人已註冊
在此指導項目中,您將:

Use a Filter to remove outliers in the data.

Combine the data using Pandas Merge.

Sort the data by rainfall and temperature.

Clock1 hour
Intermediate中級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

Visualizing data patterns often involves re-arrangement and elimination to determine patterns. For example, in a list of data with yearly rainfall amounts, to quickly determine the years with the most rainfall, the data can be sorted according to rainfall in descending order. A filter could be used to limit the amount of data observed, for example, to only show rainfall amounts greater than an inch. A merge can be used to join two datasets together, for example rainfall and temperature data from two different sources. The ability to sort, merge and filter data has always existed using SQL with database data, now it can be done in application memory space using Python. In this course, you will create an application that reads data from two CSV files. You will learn how to merge, sort, and filter the data to ultimately produce a regression plot to determine a possible correlation between two data sets.

您要培養的技能

Data SciencemergingPython ProgrammingfilteringPandas

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  1. Read the data into a Pandas DataFrame.

  2. Use a Filter to remove outliers in the data.

  3. Combine the data using Pandas Merge.

  4. Sort the data by rainfall and temperature.

  5. Use the Seaborn package to create a regression plot.

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

審閱

來自MERGE, SORT AND FILTER DATA IN PYTHON PANDAS的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心