Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Make Your Code Beautiful | Dealing With Conditions
course content

Зміст курсу

Advanced Techniques in pandas

1. Get Familiar With Indexing and Selecting Data

Output Columns by TitleOutput Rows by IndexSelect Specific Rows and ColumnsLearn More About IndexationGet Familiar With lambda FunctionsExpand Functionality of the .iloc[] Function

2. Dealing With Conditions

Set ConditionSelect Data Based on ConditionDealing With Several ConditionsMake Your Code BeautifulConditions Quiz

3. Extract Data

Is Data in ...?Combine Your KnowledgeBetween FunctionExtract Specific DataFind the Smallest Values of a ColumnFind the Largest Values of a ColumnFind the Correlation

4. Aggregating Data

Get Familiar With the .groupby() MethodGroup by Several ColumnsComplicated GroupingGroupDealing With Pivot TablesCreate a Pivot Table

5. Preprocessing Data

Check for Missing ValuesCalculate the Number of Missing ValuesWhat Will We Do With the NaN Values?How to Delete Only NaN Values?Fill In the Missing ValuesManage Categorical VariablesCheck the Column TypeManage an Incorrect ColumnRename the Column

Advanced Techniques in pandas

Make Your Code BeautifulMake Your Code Beautiful

Let's make our code more convenient and more readable. By the way, it is essential to make your code understandable for your coworkers.

To simplify the code, we can write the condition first and then put it into the .loc[] function; look at the example from the previous chapter:

The first and second methods lead to the same output, but the second is much better for understanding because you can work with two conditions separately, and the statement within the .loc[] function takes up less space.

Завдання

Your task here is to consolidate knowledge from this chapter. You need to extract data on small asteroids with a high magnitude, or hazardous ones. To do so, follow the algorithm:

  1. Write the first condition: values from the column'est_diameter_min' are less than 0.01. Assign it to the variable condition_1.
  2. Write the second condition: values from the column 'absolute_magnitude' are greater than 20. Assign it to the variable condition_2.
  3. Write the third condition: values from the column 'hazardous' are equal to False. Assign it to the variable condition_3.
  4. Write the general condition that satisfies the requirement: (condition_1 and condition_2) or condition_3.

Все було зрозуміло?

Секція 2. Розділ 4
toggle bottom row
course content

Зміст курсу

Advanced Techniques in pandas

1. Get Familiar With Indexing and Selecting Data

Output Columns by TitleOutput Rows by IndexSelect Specific Rows and ColumnsLearn More About IndexationGet Familiar With lambda FunctionsExpand Functionality of the .iloc[] Function

2. Dealing With Conditions

Set ConditionSelect Data Based on ConditionDealing With Several ConditionsMake Your Code BeautifulConditions Quiz

3. Extract Data

Is Data in ...?Combine Your KnowledgeBetween FunctionExtract Specific DataFind the Smallest Values of a ColumnFind the Largest Values of a ColumnFind the Correlation

4. Aggregating Data

Get Familiar With the .groupby() MethodGroup by Several ColumnsComplicated GroupingGroupDealing With Pivot TablesCreate a Pivot Table

5. Preprocessing Data

Check for Missing ValuesCalculate the Number of Missing ValuesWhat Will We Do With the NaN Values?How to Delete Only NaN Values?Fill In the Missing ValuesManage Categorical VariablesCheck the Column TypeManage an Incorrect ColumnRename the Column

Advanced Techniques in pandas

Make Your Code BeautifulMake Your Code Beautiful

Let's make our code more convenient and more readable. By the way, it is essential to make your code understandable for your coworkers.

To simplify the code, we can write the condition first and then put it into the .loc[] function; look at the example from the previous chapter:

The first and second methods lead to the same output, but the second is much better for understanding because you can work with two conditions separately, and the statement within the .loc[] function takes up less space.

Завдання

Your task here is to consolidate knowledge from this chapter. You need to extract data on small asteroids with a high magnitude, or hazardous ones. To do so, follow the algorithm:

  1. Write the first condition: values from the column'est_diameter_min' are less than 0.01. Assign it to the variable condition_1.
  2. Write the second condition: values from the column 'absolute_magnitude' are greater than 20. Assign it to the variable condition_2.
  3. Write the third condition: values from the column 'hazardous' are equal to False. Assign it to the variable condition_3.
  4. Write the general condition that satisfies the requirement: (condition_1 and condition_2) or condition_3.

Все було зрозуміло?

Секція 2. Розділ 4
toggle bottom row
some-alt