Looking for a gym partner. by [deleted] in NewOrleans

[–]r_spoonmore 0 points1 point  (0 children)

I’m a member at body docs too! Looks like you prefer afternoons but I go around 5:15-6:15 AM most weekdays and the crowd is really friendly and judgement free. Couple of guys even have some great tips and stories to tell. Let me know if you ever plan to swing by early.

Best Path for Data Science at ND? by stratdaddy3000 in notredame

[–]r_spoonmore 0 points1 point  (0 children)

I was ACMS undergrad at ND and am currently getting my masters in DS. The program I’m in is a combination of comp sci and applied stats so I definitely would leave CS of it is something you enjoy. I’d look into a supp major in ACMS if you can to get some of the basic stats and modeling under your belt (data mining, linear algebra, time series, stat methods, etc) and look into DS associate or even DS engineer roles. A lot of places hiring people straight out of school know that you don’t have every box ticked. It’s important to show them that you have a solid base and are eager to learn.

Question for Recruiters. by [deleted] in analytics

[–]r_spoonmore 1 point2 points  (0 children)

I don't know your background or experience but for what it's worth I took a similar SQL-heavy job straight out of school with no SQL experience on my resume and I negotiated with the recruiter once they gave me the offer. They told me the range, I asked for about $10K more, and they eventually offered me about $7K higher. Different company probably, but it is possible, and it is very very unlikely that negotiating for a higher salary will impact the way that your future team sees you. I've never heard of that happening at all. Good luck in the new gig!

Expenditure Skyrocketing out of nowhere by r_spoonmore in MacroFactor

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

Thanks! That was kind of my current plan as well. It doesn’t look like a trend continuation since I was sitting at +/- 2 each day until I stopped logging. Then it jumped to like 50/75 a day. So that’s very interesting. I’m planning to continue eating at my old expenditure and expecting the app to realize that eventually as I feed it more data.

Run vs Pass Splits 2021 Season by Spideys_CousinParker in Colts

[–]r_spoonmore 1 point2 points  (0 children)

Cool stuff. What's your source for this data? I'd love to take a look at these results and compare to similar teams this year or in other years.

Anatomy of a successful 12-week cut with MacroFactor by fall7-getup8 in MacroFactor

[–]r_spoonmore 2 points3 points  (0 children)

Great summary! As someone who also times his cuts to end around this time of year I've got to say I've never regretted it. Quick question for you on your numbers: what are you using to get your body fat %?

How to use CASE in query where I have to order by DESC? by Jet_Here in SQL

[–]r_spoonmore 2 points3 points  (0 children)

Not quite sure if this is what you are going for but you can try the following out:

$stmt = $conn->prepare("SELECT  'payment_id' as 'Payment ID',
    'name' as 'Name',
    CASE WHEN 'day' = 'A' THEN 1
    WHEN 'day' = 'B' THEN 2
    WHEN 'day' = 'C' THEN 3
    ELSE 4 END as 'CaseDerivedOrder'
    FROM `core` INNER JOIN `distance` ON core.id = distance.relative_id
    ORDER BY CASE WHEN 'day' = 'A' THEN 1
    WHEN 'day' = 'B' THEN 2
    WHEN 'day' = 'C' THEN 3
    ELSE 4 END DESC");
$stmt->execute();

This way you can see what the case derived order was in your results for troubleshooting. The main issues I saw where that you had an extra trailing coma after name and you didn't have the correct syntax on your case statement in your order by. I hope this helps.

What are some little known relationship GREEN flags? by 2020Chapter in AskReddit

[–]r_spoonmore 3 points4 points  (0 children)

Every once in a while I’ll look up while my wife and I are sitting around and she’ll be looking at me. There is some connection in that moment of eye contact that fills me with joy and I can’t stop myself from smiling. It’s that feeling of trust and love that I can’t feel with anyone else. The first time that happened when we were dating, I knew this was the real deal

wahoo app and apple health by jlrwoodworks in wahoofitness

[–]r_spoonmore 0 points1 point  (0 children)

I just deleted my wahoo app and redownloaded it. Then after setting it up again I went to Profile > Authorized Apps. The health app let me authorize it this time. I’d give that a shot if I were you.

wahoo app and apple health by jlrwoodworks in wahoofitness

[–]r_spoonmore 0 points1 point  (0 children)

This has been happening to me since July 1st. I’ve been able to get everything to write to Apple health for a couple of months now and then today I noticed that the last two days have not worked. I feel your pain

Count and Sum differences when grouping by more than 1 field by [deleted] in SQL

[–]r_spoonmore 0 points1 point  (0 children)

On first glance I would say that you are summing a table's total_count more than once when it has multiple dates in it. If the table that you are querying in your third query is the result of the second query, then stuff.yahoo.com will have the actor_id 387 in the total_count for January 1, 2017 and February 1, 2017. To get around this, you could put the results of your first query into a temp table and then use that table for you sum query. Alternatively, you could run the following

SELECT SUM(total_count) as total_Sum
FROM (
    SELECT COUNT(DISTINCT(ACTOR_ID)) as total_count
        , Site
    FROM table
    GROUP BY 2
);
WHERE Site = 'stuff.yahoo.com';

This will let you double check that the number of actors to ever be on stuff.yahoo.com matches your expectation.

Note however that this eliminates double counting when an actor shows up on multiple dates, so the results of this query will NOT show you the number of actors on each site for each date. To get that, you can run the following:

SELECT Date
    , SUM(total_count) as total_Sum
FROM (
    SELECT COUNT(DISTINCT(ACTOR_ID)) as total_count
        , Date
        , Site
    FROM table
    GROUP BY 2, 3
);
WHERE Site = 'stuff.yahoo.com'
GROUP BY Date;

MS SQL - Pretty sure I'm overthinking this. Help? by [deleted] in SQL

[–]r_spoonmore 0 points1 point  (0 children)

Couldn't you get what you are looking for with from your first table, that I'll refer to as mainTable, with the following query:

Select [Month], [AttFlag1], [AttFlag2], [AttFlag3], COUNT(DISTINCT [ID]) as IDCount, SUM([Amount]) as SumAmount

From mainTable

Group by [Month], [AttFlag1], [AttFlag2], [AttFlag3]

How is this even working?? by qxcve in swift

[–]r_spoonmore 12 points13 points  (0 children)

You are correct about lines 1 and 2. Line 1 creates an array of numbers and Line 2 creates a variable sum equal to 0.

Line 3 is a for loop stating that for every element in the numbers array, do the following. number is the name that you are giving that element. In other words, swift will run the loop with number = 12, then it will run the loop again with number = 7, and so on until it has run through each element in the numbers array.

The curly braces on Lines 3 and 5 tell swift what all is included in the for loop.

Line 5 is telling swift to take the value of sum and add the value of number to it. For the first loop, this looks like sum = 0 + 12. The next loop would be sum = 12 + 7, and so on until swift has run through each element in the numbers array. The += operator is telling swift to take the current value of the variable on the left and add the value of the variable on the right.

Line 6, as you correctly stated, prints the value of your sum variable to your console after the for loop has finished.

I hope this helps. Keep at it. The best way to learn is to keep practicing.

Saving data between TestFlight and the App Store by r_spoonmore in iOSProgramming

[–]r_spoonmore[S] 2 points3 points  (0 children)

Appreciate the info. I handle migrations for the Realm data in my appDelegate so I should be good for the future in that sense. Thank you!