fyi all - I have posted the link to last week's session at the top of last week's event - you can find it on newyork.iiba.org

For anyone looking for the recorded link for last weeks meeting, here it is. Normally it is on the same page as Kerren said. Direct link to Zoom Cloud... https://iiba-org.zoom.us/rec/share/9yJnBBRoyv05lmHdMKPNIe8Zt-HJZUEvqUf4K0XTHqmi8SFcNuX3A4-z85qrjPTr.kwBL-k0EtuxArYsq

Hi! Im an accountant at a company called Intermedia

I work with Jake

sorry no mic

Link for using Python online: https://www.online-python.com/

Ekta - is that any different than launching from Anaconda Navigator?

Jupy is open

Jupyter is open on my end

open

Should we open our file from last time or a new file?

[0]

print(x[0])

x[-1]

x[1:3]

x[2:5] yes no?

x[1:3]

x[1:4]

I had to do some trial and error to get there

tuple is immutable

mutable vs non-mutable

list = mutable

also referred to as key/value pair, correct?

x = {"UK" : "London", "US" : "Washington DC", "India" : "New Delhi"}

Done

done

Done

done

done

Can you always overwrite what you have previously defined (for example 'x')?

yep - done

success

done

done

👍

success

done

done

deleted 👌

done

deleted

my_dict = {'ProductID' : [101,102,103,104,105],'Product Name' : ['Cadbuary Chocolate','Dove Shampoo','Colgate','Water','Lipstick'],'SellingPrice' : [1.65,3.99,2.45, 0.37, 1.99]}

https://www.analyticsisnormal.com/post/data-structures-in-python

This is the tutorial we had referred for today's session

my_set = {'Cadbuary Chocolate','Dove Shampoo','Colgate','Water','Lipstick','Colgate','Colgate','Lipstick'}

done

done

done

1. Create a set2. Add an element to the set3. remove an element from the set

The link on the website should be working now.

👍

done

done

https://www.analyticsisnormal.com/post/user-defined-functions-udfs-in-python

I need to drop off. It was great learning from Ekta. Thanks.

Thanks very much Keren.

def cube_function(x):return(x**3)

def cube_function(x):return(x**3)

z = 1000def myfunc(x,y):z = x * yreturn(z)myfunc(2,10)z

def myfunc(x,y):print("The value of x and y is", x, y)z = x * yreturn(z)myfunc(2,10)x = myfunc(2,10)x

When is Python used instead of SQL?

Thanks very helpful explanation

You said these are libraries, correct? for different functionalities?

import pandas as pd

yes thank you

def myfunc(x,y):return(x**y)myfunc(2,3)myfunc(3,2)myfunc(y = 3, x = 2)

Thanks for the lessons today Ekta, have to drop now! Thanks Kerren for organizing!

https://www.analyticsisnormal.com/post/user-defined-functions-udfs-in-python

https://www.analyticsisnormal.com/python

Have to drop - THANK YOU EVERYONE!!!! :)

is the user able to delete lines in the notebook to clean it up?

­­­­­Interesting article about learning and memory: https://www.mindtools.com/a9wjrjw/ebbinghauss-forgetting-curve Thanks you Ekta for stressing returning to the material within 24 hours and Kerren for multiple sessions

I see. Understood, thanks!