Deck 1

Question 1

Adoption of home broadband has stalled in the United States

Answer 1

stopped moving or developing

Question 2

Beautifulsoup how to print clearly the content of ‘soup’

Answer 2

soup.preffity()

Question 3

Dimensions du DataFrame boston ?

Answer 3

boston.shape

Question 4

How to create a cross validation set with sklearn ?

Answer 4

X_train, X_test, Y_train, Y_test = cross_validation.train_test_split(X,Y,test_size=0.3,random_state=0)

Question 5

How to get boston sklearn data to pandas

Answer 5

bos = pd.DataFrame(boston.data)
bos.columns = boston.features_names

Question 6

How to have infos on columns in pandas

Answer 6

df.info()

Question 7

How to know the types of columns in pandas

Answer 7

df.dtype

Question 8

plot boston crime vs boston housing price

Answer 8

plt. scatter(bos.CRIM, bos.PRICE)
plt. xlabel(“Per capita crime rate by town (CRIM)”)
plt. ylabel(“Housing Price”)
plt. title(“Relationship between CRIM and Price”)

Question 9

quelles options sont dispo dans pandas ?

Answer 9

pd. set_option(‘display.width’, 500)
pd. set_option(‘display.max_columns’, 100)
pd. set_option(‘display.notebook_repr_html’, True)

Question 10

Relational Database principle ?

Answer 10

Don’t say seek 20 bytes onto disk and pick up from there. Say : selecta data from a set. I dont care where it is, just get the row to me

Question 11

Replace missing values in Age of Titanic passengers with mean value of Ages

Answer 11

df1[‘Age’][np.isnan(df1[‘Age’])] = np.median(df1[‘Age’])
or
test.Age = test.Age.fillna(np.median(test[‘Age’]))

Question 12

Rester au courant de l’actualité en anglais?

Answer 12

Keeping up with news

Question 13

The decline “could represent a blip or might be a more prolonged reality,”

Answer 13

Something that does not last

Question 14

Import module for regular expressions

Answer 14

Import re

Question 15

How to import float division

Answer 15

From __future__ import division

Question 16

Comment créer une exception lors d’un division par 0

Answer 16

try:
Print 0/0
except ZeroDivisionError:
print “cannot divide by 0”

Question 17

Comment unpack une liste [1,2]

Answer 17

X,y=[1,2]

Question 18

Import module for regular expressions

Answer 18

Import re

Question 19

How to import float division

Answer 19

From __future__ import division

Question 20

Comment créer une exception lors d’un division par 0

Answer 20

try:
Print 0/0
except ZeroDivisionError:
print “cannot divide by 0”

Question 21

Comment unpack une liste [1,2]

Answer 21

X,y=[1,2]

Question 22

Swap variables

Answer 22

X,y =y,x

Question 23

How to print work directory ?

Answer 23

import os
os.getcwd()
OR
pwd dans le shell

Question 24

How to set work directory to path

Answer 24

import os

os.chdir(path)

Question 25

How to run a script automatically every minute?

Answer 25

import time
while True:
script += 1
time.sleep(60)

Question 26

How to connect bing API and convert to Json

Answer 26

response = urllib2.urlopen(urlbing).read()
data = json.loads(response.decode('utf8'))

Question 27

How to plot two curves on two different axis?

Answer 27

fig = plt.figure()
ax1 = fig.add_subplot(111)
ax1.plot(dfel.sort().index.to_datetime(),dfel.sort())
ax1.set_ylabel(‘Consommation electrique France (MW)’)

ax2 = ax1.twinx()
ax2.plot(dfth.sort().index.to_datetime(),dfth.sort(), color=’r’)
ax2.set_ylabel(‘Indice de congestion Paris’, color=’r’)
for tl in ax2.get_yticklabels():
tl.set_color(‘r’)

plot.show()

Question 28

read zip file

Answer 28

import zipfile
file_to_read = zipfile.ZipFile(‘exemple.zip’)
file_to_read.namelist() #displays content of zip
file_to_read.read(‘file1.txt’)

Question 29

find and return a string of digits in a string

Answer 29

import re

numbers = re.search(‘\d+’ , string_to_read).group(1)