Change the order of columns in a Python Pandas DataFrame

import pandas

data = {
    "Product": ["Apple", "Orange", "Pear"],
    "Selling Price": [2, 3, 4],
    "Cost Price": [1, 2, 3],
}
df = pandas.DataFrame(data)
print(df)

# output:
#   Product  Selling Price  Cost Price
# 0   Apple              2           1
# 1  Orange              3           2
# 2    Pear              4           3

df = df[["Product", "Cost Price", "Selling Price"]]
print(df)

# output:
#   Product  Cost Price  Selling Price
# 0   Apple           1              2
# 1  Orange           2              3
# 2    Pear           3              4

import pandas

data = {
    "Product": ["Apple", "Orange", "Pear"],
    "Selling Price": [2, 3, 4],
    "Cost Price": [1, 2, 3],
}
df = pandas.DataFrame(data)
print(df)

# output:
#   Product  Selling Price  Cost Price
# 0   Apple              2           1
# 1  Orange              3           2
# 2    Pear              4           3

column_names = list(df.columns.values) # will be ["Product", "Selling Price", "Cost Price"]
column_names.insert(1, column_names[-1])  # insert last element of list at index 1
column_names.pop()  # remove last element of list
df = df[column_names]
print(df)

# output:
#   Product  Cost Price  Selling Price
# 0   Apple           1              2
# 1  Orange           2              3
# 2    Pear           3              4

import pandas

data = {
    "Product": ["Apple", "Orange", "Pear"],
    "Selling Price": [2, 3, 4],
    "Cost Price": [1, 2, 3],
}
df = pandas.DataFrame(data)
print(df)

# output:
#   Product  Selling Price  Cost Price
# 0   Apple              2           1
# 1  Orange              3           2
# 2    Pear              4           3

column_names = list(df.columns.values) # will be ["Product", "Selling Price", "Cost Price"]
column_names.sort()  # sort names alphabetically
df = df[column_names]
print(df)

# output:
#    Cost Price Product  Selling Price
# 0           1   Apple              2
# 1           2  Orange              3
# 2           3    Pear              4

Get Started With Sentry

Get actionable, code-level insights to resolve Python performance bottlenecks and errors.

1. Create a free Sentry account

2. Create a Python project and note your DSN

3. Grab the Sentry Python SDK

pip install --upgrade sentry-sdk

4. Configure your DSN

import sentry_sdk

sentry_sdk.init(
    "https://<key>@sentry.io/<project>",

    # Set traces_sample_rate to 1.0 to capture 100%
    # of transactions for performance monitoring.
    # We recommend adjusting this value in production.
    traces_sample_rate=1.0,
)