profitsWorked.ipynb

Kernel: Python 3 (system-wide)

from datascience import *

# Find Profitability for each market in the profits.csv file.jjj
mydata = Table.read_table('profits.csv')

mydata

Market	Revenue	Expense
Omaha	750000	800000
Lincoln	600000	600000
Kearney	300000	250000

profit = mydata.with_column('Profit/Loss', mydata.column('Revenue') - mydata.column('Expense'))
profit.sort('Market')

Market	Revenue	Expense	Profit/Loss
Kearney	300000	250000	50000
Lincoln	600000	600000	0
Omaha	750000	800000	-50000