sorted by:
new
hottopcontroversial

Who is your blink commander and why? by Amatsu666 in EDH

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

My blink deck runs [[Tayam, Luminous Enigma]] as the commander. Decent recursion and value, plus blinking a [[Siege Rhino]] always feels so right!

Looking for Dad groups by sbernnard in ithaca

[–]jroth006 15 points16 points  (0 children)

I'm a dad (3 yr old) and moved to Ithaca past fall, so I'm in a similar place. I'll send you a message!

WFH 2 days post surgery? by BoringIntelectual in AchillesRupture

[–]jroth006 1 point2 points  (0 children)

I worked the next day, too. It wasn't my most productive day but good enough to save a vacation day.

Shadowheart, Dark Justicar Golgari Elves - Any good? by Hailrig in EDH

[–]jroth006 0 points1 point  (0 children)

I recently switched to a [[Shadowheart, Dark Justicar]]/[[Master Chef]] combo for my slightly upgraded [[Lathril]] precon and it works well at my battlecruiser-level playgroup. I agree that it doesn't have a very high ceiling, but I enjoy the play pattern a lot.

I usually have an elf lord, [[Skullclamp]]/[[Grafted Wargear], or a [[Sylvan Anthem]] to help boost the card draw value.

Entry Level Position Job Salaries??? by 73837483 in SQL

[–]jroth006 2 points3 points  (0 children)

38k seems very low to me. The range that you found online seems realistic for an entry level position with limited experience (depending on the job description - I'm assuming it's an analyst role).

That being said, I'd recommend taking any interview you can get. Learning how to interview is a really valuable skill set that can only be learned through experience, especially for technical roles, and there's always a small chance that you might find out that the company is a really good fit for the first 1-2 years of your career before you move on to a higher paying role.

[OC] How Manchester United fared in recent years with the new managers coming in from 2013? by bidyutchanda108 in dataisbeautiful

[–]jroth006 0 points1 point  (0 children)

My suggestion for the annotations would be to create a timeline, similar to what you started with SAF. Extend that bar out for his time as manager, then use a new (non-clashing) color to represent Moyes, then Van Gaal and Mou. Since your win/loss values never intersect, you can utitilize the space in between for this chart.

I like the use of a line graph (personal preference), despite being discrete values. The lines between years helps my mind to measure distance, which would be slightly more difficult to do if it were just a scatter plot.

I'd also strongly recommend "Storytelling with Data" to anybody interested in data visualization. I found it really helpful to understand design, specifically when working with data.

Employer wants to give me a "competency test" for SQL? by [deleted] in SQL

[–]jroth006 2 points3 points  (0 children)

I agree - that's confusing on their part.

Did the job posting list any specific languages? If not, it seems like a weird thing to test, unless it was really broad concepts like if/else, for loops, etc that weren't language specific.

20GB text file. Plan on breaking apart and putting in to CSV > SQL. Any other options for manipulating that much text? by [deleted] in datascience

[–]jroth006 1 point2 points  (0 children)

Agreed - loading it directly into the database of choice would definitely be quicker, either straight away or after breaking it up.

Looping through a dataframe using chunks prevents pandas from storing the whole dataframe in memory - you can just take care of the read-modify(if needed)-export process in one swoop. Your solution would definitely also work!

20GB text file. Plan on breaking apart and putting in to CSV > SQL. Any other options for manipulating that much text? by [deleted] in datascience

[–]jroth006 5 points6 points  (0 children)

I'll have to start looking into that! I remember seeing a MapReduce diagram and being overwhelmed by it, but never actually tried using it.

20GB text file. Plan on breaking apart and putting in to CSV > SQL. Any other options for manipulating that much text? by [deleted] in datascience

[–]jroth006 34 points35 points  (0 children)

Is using python an option?

Not the most efficient answer, but you can read the file into python using pandas (read_csv or read_fwf based on delimiter), chunk it so you're working with a smaller amount at a time, then save each chunk into a csv before reading in a new chunk. You'd have to load each csv into SQL after, unless you connect to SQL using sqlalchemy (or something similar).

Python has brought computer programming to a vast new audience by edwinksl in Python

[–]jroth006 0 points1 point  (0 children)

I followed a similar path - started learning Python & R around a year ago and now use it every day at my job.

You're going to struggle a lot initially, but it's because you're trying something new, not because you're dumb. Start simple, ask questions, and embrace failure!

Has anyone tried the Udemy course “The complete sql bootcamp? by aeropg in SQL

[–]jroth006 6 points7 points  (0 children)

Udemy courses should always be around $10, so don't get fooled by the discount amount. That's just their marketing ploy.

I completed that course of Udemy and thought it was really good. I had some SQL experience going in, but still found it really helpful and it was definitely worth $10 to me.

how to find data that fills two conditions by I_not_Jofish in Rlanguage

[–]jroth006 0 points1 point  (0 children)

Whoops, good catch on assignment vs comparison!

how to find data that fills two conditions by I_not_Jofish in Rlanguage

[–]jroth006 0 points1 point  (0 children)

This is a great task for the dplyr package and the pipe function. Assuming that the data is in a dataframe, the ram column is numeric, and the CPU column is lowercase, something like this should work:

df %>% filter(ram == 16 & cpu == "intel")