3.7) Pandas: Pivoting from 'Long' to 'Wide' Format

1.1) Why Python?

1.2) Why run Python code in Google Colab?

1.3) Why learn Python in DataCamp?

1.4) Why learn Python in Dataquest?

1.5) Introduction to Markdown in Google Colab

1.6) Learn Latex in Google Colab

1.7) Upload Data in Github to Open in Google Colab

2.1) NumPy: Data Types

2.2) NumPy: Creating Array

2.3) NumPy: Increment Operator

2.4) NumPy: Mean, Standard Deviation

3.1) Pandas: Introduction to Series

3.2) Pandas: DataFrame

3.3) Pandas: Reading Excel Files in Google Colab

3.4) Pandas: Reading CSV or Text Files in Google Colab

3.5) Pandas: Merging Dataframes

3.6) Pandas Concatenate or Append Function

3.7) Pandas: Pivoting from "Long" to "Wide" Format

3.8) Pandas: Mean of a Variable with Conditions

3.9) Pandas: Recode Categorical Variable

3.10) Pandas: Filter Columns and Rows

3.11) Load Excel/CSV Files into Google Colab

3.12) Series vs Dataframe vs MultiIndex (Panel)

4.1) Matplotlib: Introduction

4.2) Matplotlib: Boxplot and Histogram

4.3) Matplotlib: Scatterplot

4.4) Matplotlib: Figure vs Axis

5.1) Plotly: Dynamic Scatterplot with Clusters

5.2) Plotly: Dynamic Histogram with Vertical Line

5.3) Plotly: Bar Chart

6.1) Python: Function, Conditional Statement, Data Transformation

6.2) Python: Loop over List, String, Dictionary, and Numpy Array

6.3) Fibonacci: Recursion vs Loop

6.4) Python: Loop to Simulate Coin Tosses

6.5) Python Loop, List Comprehension, and Lambda Function

6.6) Python: *args vs **kwargs

6.7) What the Arrow Means in Python Function Definition?

7.1) Everything in Python is an Object

7.2) Learn How to Create a Class in Python

8.1) DataCamp Signal Assessment: Python Programming

[jehanalsidi]

I like how easy it is to pivot the table from “ long” to “wide”.

[miolagailocampo]

Is there a specific purpose to pivoting tables, or is it more of a preference in look situation?

[fayezsalame]

A simple method but very useful, I wonder why it wasn't mentioned much on DataCamp?

[stephanieprice-cummings]

I saw that another way to pivot is using the melt() function, could you explain how that function works and if it is anymore useful than just doing it this way?

[bacharahmad]

i wasn't able to use Wide['Year'], for example, but still able to use iloc. do you lose the ability to identify columns by their name when you pivot?

[farahkaddoura]

Can we have more than 9 values? or is it only from 0 to 9? thanks!

[hashwi]

Is this just a preference or is there a specific reason people choose to pivot tables