Use pivot_table instead of pivot or unstack

This page is not yet available in Spanish. We are working on its translation.
If you have any questions or feedback about our current translation project, feel free to reach out to us!

Metadata

ID: python-pandas/pivot-table

Language: Python

Severity: Notice

Category: Best Practices

Description

The functions isna and isnull are similar. However, this is a best practice to use isna since other methods use the same naming patterns.

Learn More

Non-Compliant Code Examples

table = df.unstack(level=0)
table = pd.pivot(
        df,
        index='foo',
        columns='bar',
        values='baz'
        )

Compliant Code Examples

table = df.pivot_table(
        df,
        values='D',
        index=['A', 'B'],
        columns=['C'],
        aggfunc=np.sum,
        fill_value=0
https://static.datadoghq.com/static/images/logos/github_avatar.svg https://static.datadoghq.com/static/images/logos/vscode_avatar.svg jetbrains

Seamless integrations. Try Datadog Code Analysis