CommencerCommencer gratuitement

Creating columns

Sometimes we have to create new columns based on the data we have in order to better represent the information we currently have. For example, maybe we care more about the dollar value of our ticket sales than just the actual quantity of tickets we've sold.

Cet exercice fait partie du cours

Python for Spreadsheet Users

Afficher le cours

Instructions

  • Create a new column in sales called sales_usd, equal to ticket_quantity multiplied by 20.
  • Print the head of sales.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Import the pandas package as pd
import pandas as pd

# Read in the Excel file
sales = pd.read_excel('ticket_sales.xlsx')

# Create a sales_usd column
sales[____] = sales[____] * ____

# Print the head of sales
Modifier et exécuter le code