Python Basics

#importing packages import pandas as pd import numpy as np import seaborn as sns

print("Hello World")

Hello World

#adding two numners 2 + 5

#defining a function def add_number(a, b): return a + b;

#calling function add_number(10, 20)

a = [4, 5, 9, 3] a

a[2]

a[1:3]

nb = pd.read_csv("listings.csv") nb.head()

idint64

nameobject

29150746

Waterfront privacy - Cozy vacation home

46150140

Cozy camp 2

36698598

BaieSteAnneCottage.Minimum 7 nights summer month

552500

Maine Riverfront Bed and Breakfast ROOM 3

7797124

Best Cottage on the Bay of Fundy

nb.tail()

idint64

nameobject

2960

5418416

Bay of Fundy Winterized Cottage

2961

610019261928093921

Chalet tout confort avec magnifique vue sur la mer

2962

54220114

Bright and Cheerful Coastal Cottage

2963

50240177

Waterfront 2-bedroom! Paradise at your fingertips!

2964

5684585

Oceanfront Rancher- Spectacular Views

nb['name'].head()

nb.columns

cols = ['name', 'host_name'] nb[cols]

nameobject

🥰 Wow! Enjoy Nice & Clean 2 bedrooms ap NBCC MONCT0.6%

🥰 Wow! Enjoy Nice & Clean 3 bedrooms NBCC Moncton0.3%

2891 others99.1%

host_nameobject

Rafael2%

Bower Hotel1.2%

1075 others96.9%

Waterfront privacy - Cozy vacation home

Tim

Cozy camp 2

Daniel & Randalyn

BaieSteAnneCottage.Minimum 7 nights summer month

Colin

Maine Riverfront Bed and Breakfast ROOM 3

Karen

Best Cottage on the Bay of Fundy

Julie

Maine Riverfront B&B Lodging ROOM 2

Karen

Cottage in New-Brunswick

Maurice

It's About Time Unit #1 & Unit 2 (whole house)

Elizabeth And Michael

Captain's Cabin

Louis

Lamb Cove Cottage

Louis

#calculate using two columns; #a new column will be created and appended at the end of the columns(last column) nb['min_rev'] = nb['minimum_nights'] * nb['price']

# just to see if column is added at the end of the dataframe(table) nb.head()

idint64

nameobject

29150746

Waterfront privacy - Cozy vacation home

46150140

Cozy camp 2

36698598

BaieSteAnneCottage.Minimum 7 nights summer month

552500

Maine Riverfront Bed and Breakfast ROOM 3

7797124

Best Cottage on the Bay of Fundy

round(nb['min_rev'].mean(), 2)