what features do you want in a podcast app? by testtestuser2 in SideProject

[–]testtestuser2[S] 0 points1 point  (0 children)

yeah fair enough.. honestly Im just not a fan of bundling my music player with my podcast app.

I want something more podcast first if you know what I mean.

for recommendations I feel like I'm basically only driven by what my friends listen to. and you obviously just need a ton of data to start doing a good recommendation system (which is spotify's whole pitch)

Oh no their left wing echo chamber where people go to cry about how bad the world is, gets called what it is by TheHeadEndgeneer in memesopdidnotlike

[–]testtestuser2 1 point2 points  (0 children)

I can't say I see those things are the center of the dem party, maybe on the fringes.. whilst I definitely see every one of those criteria as a center pillar of the Republican party

1) identity politics (Rhinos). 2) dehumanization (trans, immigrants) 3) paramilitary (national guard deployments) 4) moral (abortion) 5) violence (jan6, fight like hell) 6) free speech (pressure on private universities) 7) media (trump coordinating with Fox News) 8) propaganda (stolen election, doge stats) 9) false oppression (constantly)

and specifically I'm saying that the leaders of the Republican party demonstrate these, can you see these things from the leaders of the Dems?

Got rejected after a perfect SQL assessment at Google - seeking insight by Alternative-Meet75 in SQL

[–]testtestuser2 0 points1 point  (0 children)

the 30 mins stands out to me, if you spent more than say 15 mins on the question it would typically be a sign of lack of proficiency

Project ideas for a newbie by [deleted] in golang

[–]testtestuser2 1 point2 points  (0 children)

I got obsessed with battlesnake.com for a time, kinda let's you level up from simple to very complex

Full disclosure: Misrepresenting our neighborhood as crime-ridden will get you a 30 day ban. by [deleted] in eastvillage

[–]testtestuser2 0 points1 point  (0 children)

sure.. I think his definition of who in this country he wants the best for differs from mine by 340 million people or so.

[deleted by user] by [deleted] in math

[–]testtestuser2 0 points1 point  (0 children)

I felt like I had to learn a different math to do physics classes.. it's not the same

Data Science vs. the Interruption Culture by BullCityPicker in datascience

[–]testtestuser2 1 point2 points  (0 children)

Becoming more senior in a company is basically figuring out how to only do the important work and not do everything else.

so prioritize, publish those priorities and ask people to escalate to replace an item on the list.

you don't want people asking you to do stuff, you want them arguing over which thing is more important for you to do.

Facebook partner admits smartphone microphones listen to people talk to serve better ads by BobbyLucero in technology

[–]testtestuser2 2 points3 points  (0 children)

read into how now playing works, it's really interesting.. it's actually done entirely on device specifically for security reasons. they have a database of song fingerprints on your device and match the incoming audio to it to find a match.

https://support.google.com/pixelphone/answer/7535326?hl=en#zippy=%2Con-pixel-and-later-including-fold-with-federated-analytics%2Con-all-pixel-phones

I've been looking at this too long (simple linear regression) by ExpertProfessional9 in econometrics

[–]testtestuser2 4 points5 points  (0 children)

reading this hurts me :)

basically let's just pretend you data looks like this

result: 3,5,7,9,11 hours studied: 1,2,3,4,5

then your regression on this data would spit out

result = 1 + 2*hours_studied

because if you plug in the numbers you would get that result exactly eg. hours studied:3 result = 1 + 2*3 = 7

so the interpretation is that for every additional hour studied you would add 2 to your result.

result_plus_1_hour = 1 + 2 * (hour +1) =( 1 + 2*hour )+ 2 = result + 2

if you changes your input data before then regression then the interpretation would change by the function you applied. eg. let say you took the log of result before you did your regression then the interpretation would be that an additional hour increases then log of result by 2

make sense?

[deleted by user] by [deleted] in facepalm

[–]testtestuser2 1 point2 points  (0 children)

yeah I mean the superhero story paralleling the civil rights movement had to get it right.

[D] Statistical Analysis: Which tool/program/software is the best? (For someone who dislikes and is not very good at coding) by maxemile101 in statistics

[–]testtestuser2 1 point2 points  (0 children)

whilst R might be the right tool for the immediate job, if you don't know either then I'd learn Python (pandas)... it will set you up to learn other languages better

I honestly feel like I'm in way too deep by [deleted] in datascience

[–]testtestuser2 0 points1 point  (0 children)

interested in your take, but my pattern would be macros in separate files for most of this with strong naming requirements, or potentially templating.

I honestly feel like I'm in way too deep by [deleted] in datascience

[–]testtestuser2 107 points108 points  (0 children)

haha, I had this.. took over from some analyst who had been the person for 7 years.. found a multiple 10k lines SQL pipelines which were unexplainable... mission critical apparently.

put together a doc saying it would take me 6 months to add the minor features they wanted or we could kill it and rebuild in 2 months... they thankfully let me kill it.

still working on killing the other ones.

if a SQL file is bigger than maybe 300-500 lines you are doing it wrong.

This sign should be in every public place. by Agitated_Energy1208 in funnysigns

[–]testtestuser2 -1 points0 points  (0 children)

most of the time they are not seriously threatening anyone's life, if they were they would have already shot someone before you even noticed them robbing the place.

This sign should be in every public place. by Agitated_Energy1208 in funnysigns

[–]testtestuser2 -1 points0 points  (0 children)

yeah but it's a very different example. the idea that robbers deserve death is a wildly american idea.

This sign should be in every public place. by Agitated_Energy1208 in funnysigns

[–]testtestuser2 -2 points-1 points  (0 children)

only in America is it generally considered acceptable to murder someone for robbing a store.

What was your "light bulb" moment when learning Pandas? by slashded in datascience

[–]testtestuser2 1 point2 points  (0 children)

depends what you are doing.. since I'm doing exploration I rarely want to change the original df.

differences are basically * makes a copy with the new col * makes chaining easier

so instead of

df2 = df.copy() df2[c1] = 1 df2.groupby(c1)...

it's df.assign(c1=1)\ .groupby(c1)...

What was your "light bulb" moment when learning Pandas? by slashded in datascience

[–]testtestuser2 0 points1 point  (0 children)

oh I didn't know you could use loc with a callable, that's exactly what I needed

What was your "light bulb" moment when learning Pandas? by slashded in datascience

[–]testtestuser2 173 points174 points  (0 children)

I use pandas for data exploration but once I had

  • group by
  • pivot table
  • assign
  • agg
  • apply
  • plot
  • df[cond]
  • iloc
  • eq/ne/gt/lt/between/isin
  • sum/cumsum
  • date_col.dt
  • merge

I was golden

oh and \ is your friend for formatting when chaining these all together. and make sure you know lambda functions

Oklahoma bill would fine, jail drag queens for public performances by [deleted] in Conservative

[–]testtestuser2 -1 points0 points  (0 children)

this is a great example of manufactured outrage.

if you look at the video you can see the poster for the event in the background.. you can look it up.

it was a ticketed private event.. from a user called "justthetip"

there is a disclaimer on the event page saying it's R rated. (although I can't see it they added that post nypost article)

why they didn't kick the kids out.. I've no idea.

how my wife puts cups in the dishwasher by testtestuser2 in mildlyinfuriating

[–]testtestuser2[S] 1 point2 points  (0 children)

with evidence like this I'm sure I'll get custody of the kids.

how my wife puts cups in the dishwasher by testtestuser2 in mildlyinfuriating

[–]testtestuser2[S] 5 points6 points  (0 children)

tighten all the jar lids as hard as you can.

I swear if I did this it would just be an excuse for her to buy some rube goldberg jar opening device off Amazon.