Logo

DSC 10 Discussion - Shared screen with speaker view
Carlos Ricco
05:49
Hi Justin. Can you at any moment explain more about what does mean a event happens by chance?
Carlos Ricco
10:08
groupby('state).count()
Huy Trinh
10:14
groupby then count?
Justin Eldridge
10:46
Then which state has the most?
Carlos Ricco
10:48
sort_values(by count).iloc[-1]
Carlos Ricco
11:13
ups.-> get(state).iloc[-1]
Carlos Ricco
12:36
I forgot to add .reset_index()
Carlos Ricco
13:14
actually, we don't need it. just use index[-1], rather than iloc[]
Huy Trinh
17:10
pops.groupby('state/region').sum()
Carlos Ricco
23:29
using table1.merge(table2, left_on, right_index = True)
Carlos Ricco
33:57
goupby(2 columns)
Carlos Ricco
40:34
table.get(#of student).appy(func)
Huy Trinh
43:40
Is he muted?
Huy Trinh
48:05
so we have to use str.contains>
Justin Eldridge
49:33
That's certainly useful. Can you find exactly what INSTNM refers to UCSD?
Huy Trinh
50:45
oh we can search up the city
Carlos Ricco
51:30
query by 'UCSD' directly
Huy Trinh
52:12
Is it supposed to be la Jolla?
Carlos Ricco
53:01
I meant look for "University of California - San Diego" or both
Carlos Ricco
59:38
cointans()
Carlos Ricco
01:03:44
suits = np.array([my_5_cards, .split('of ')[1])
Carlos Ricco
01:05:16
Oh, I got it. WE are passing 2 arguments, not only 1
Carlos Ricco
01:13:22
compare to 5
Carlos Ricco
01:13:36
rather than >=2, ==5
Huy Trinh
01:16:27
increase times?
Carlos Ricco
01:24:06
hearts and diamonds
Carlos Ricco
01:24:20
endwith both
Huy Trinh
01:27:59
I have more question about UCSD string
Huy Trinh
01:28:07
with_earnings[with_earnings.get('INSTNM').str.contains('University of California' and 'San Diego')]
Huy Trinh
01:28:13
for example
Huy Trinh
01:28:17
we dont know the city
Carlos Ricco
01:28:55
but sometimes there are typos in dataset that we don't know...
Huy Trinh
01:29:40
Thank you
Carlos Ricco
01:29:57
me
Carlos Ricco
01:30:13
in a function that returns false or true
Carlos Ricco
01:30:34
when you save in another array and read it, it's giving us 0 or 1
Huy Trinh
01:30:53
ya that's right
Carlos Ricco
01:30:55
yes
Carlos Ricco
01:32:10
oh, it will convert from TRUE to 1 and FALSE to 0
Carlos Ricco
01:32:18
gotcha
Carlos Ricco
01:33:45
I see,
Carlos Ricco
01:33:47
tks
Huy Trinh
01:34:08
Thank you and Have a great weekend
Carlos Ricco
01:34:27
Have you heard about DataCamp?
Carlos Ricco
01:34:54
It would be nice if UCSD could give to us. They have a plan for students
Carlos Ricco
01:35:29
but it's a platform with python, just for lab,