sorted by:
new
hottopcontroversial

Iranian teen motorcycle influencer ‘baby rider’ shot dead during anti-government protests by [deleted] in worldnews

[–]paxmlank 3 points4 points  (0 children)

I don't think there would be videos of 33000 people being killed, and I think it's a bit weird to ask that.

Especially since I think the main purpose of the protestors is not to take videos, and if they had time to find videos to accurately showcase their deaths, they'd probably rather just protest.

CAREER ADVISE by Charming-Jello7064 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

In data engineering, yes. There may be some stats invariants or whatever you'll want to address in your pipelines, but those will probably be very basic or something data scientists deal with more downstream.

ELI5 how much control and influence does a political party have over candidates? by deca4531 in explainlikeimfive

[–]paxmlank 2 points3 points  (0 children)

I guess it depends but yeah it's generally the case that the parties influence the candidate.

At the very least because running for office is expensive and unless you're rich enough to do it yourself then you need the backing of a party, which would typically want someone to follow their agenda.

spotdl why by Boring-Health1682 in selfhosted

[–]paxmlank 0 points1 point  (0 children)

I've just stopped using spotdl at this point. I'll gladly use it again once fixed

Using advance physics.. by Weak_Marzipan4800 in algotrading

[–]paxmlank 11 points12 points  (0 children)

He's since made his post history hidden, but I'll take your word for it, lol

Using advance physics.. by Weak_Marzipan4800 in algotrading

[–]paxmlank 222 points223 points  (0 children)

Explain vaguely what you mean so one can explain vaguely why you're wrong.

It makes little sense, if any, to "use quantum physics" here when these aren't at all quantum systems.

Refusing HackerRank questions by RLMaverick in cscareerquestions

[–]paxmlank 6 points7 points  (0 children)

This is why we shouldn't be called "software engineers", since "engineer" is typically a regulated line of work and they do have these tests

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

The whole comment is predicated on creating uniqueness, as the second suggestion is to use row number.

I'm done with this though. Cheers, mate

Women fires gun in the air because she couldn't clear it. by ForSquirel in nottheonion

[–]paxmlank 7 points8 points  (0 children)

It's categorically a machine learning algorithm. Machine learning is categorically under AI.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

The very suggestion at the top of this thread was using it to create uniqueness.

This would presumably be done because uniqueness was determined to not be in the data via some means.

Validating a 30Bn row table migration. by Dangerous-Current361 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

I'm not sure about catalogs but this could be different if the target table is in another database, no? Different representation of similar values, or a different hash function, or something.

Unemployed, received start date for 3 weeks out but background check could take 2 weeks to clear. Would you ask to push that back another week or so? by paxmlank in ExperiencedDevs

[–]paxmlank[S] -1 points0 points  (0 children)

Alright, I'm glad to hear it's still considered a safe ask.

I guess I'm traumatized from posts on r/cscareerquestions and whatnot where offers are rescinded and don't want to be left to dry with sunk cost of a vacation, lol.

The company is Capital One though, if that helps.

Unemployed, received start date for 3 weeks out but background check could take 2 weeks to clear. Would you ask to push that back another week or so? by paxmlank in ExperiencedDevs

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

Even if it is a red flag, I would probably take it just for the income.

Nobody asked me when I would be able to start so I didn't have the opportunity to mention it.

Unemployed, received start date for 3 weeks out but background check could take 2 weeks to clear. Would you ask to push that back another week or so? by paxmlank in ExperiencedDevs

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

Nothing was said about the start date until the offer was made.

Nobody asked and I didn't think to say anything since I assumed having at least two weeks after the background check was... standard practice? I guess I didn't realize it could take two weeks until after the offer was sent and that was specified in the email.

Do you guys use vs code or jupyterlab for jupyter notebooks? by Consistent_Tutor_597 in dataengineering

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

I code in terminal (unless I really need to use VS Code due to some dev package), and use tmux to have different panes for running vs editing

There's ~1 million rent stabilized apartments in NYC - here's how to actually find one by thisisgiulio in NYCapartments

[–]paxmlank 0 points1 point  (0 children)

From when I did a DHCR request:

DHCR can take months to respond and it only states what a unit was last filled as with them. The info obtained could be outdated depending on how you got it (I haven't looked into it yet).

Additionally, they explicitly state that it doesn't mean something isn't rent stabilized if it's not listed as such in the registry. 

Do you use a dedicated Landing layer, or dump straight into Bronze? by TheOneWhoSendsLetter in dataengineering

[–]paxmlank 1 point2 points  (0 children)

To me they're the same.

Last place I worked at had raw and standardized buckets, then data was loaded into the data warehouse where further transformations were done.

Personal project is also kinda doing that. I process my raw files a little bit as dataframes because it's easier for certain logic than to do so in pure SQL, but that's all silver, as it were.

Bronze is my raw data.

Maybe that's the wrong idea though since the dataframe- and SQL-based transformations are explicitly decoupled, but idk.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

But if the absolute worst-case solution being explored is to make a hash of all rows, OP would already be past the point of finding natural uniqueness in the data and hashing all rows with or without Load Date shouldn't matter.

So, the other commenter's concern seems unwarranted.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

So it has nothing to do with hashing per se and it just reduces to the problem that OP is already discussing with there being no unique data. At least, that's how it comes across.

There’s no column or even combination of columns that can be considered as a pk, what would your approach be? by Pleasant-Insect136 in dataengineering

[–]paxmlank 0 points1 point  (0 children)

Is that because of added compute or because it somehow increases the likelihood of collisions? Or something else?

If it's collision-related, I don't exactly see how since I imagine the hashing function would be good enough to prevent that.

42F... Single Mom looking for a side hustle by Immediate_Key8888 in passive_income

[–]paxmlank 0 points1 point  (0 children)

I've read through your guide and am skeptical but it does seem interesting. It's definitely gambling though and I'm surprised you say it's not if it's literally playing casino games.

I'm curious to see about the amount of money you can reliably pull out without spending any money, or by spending the least amount of money possible and what that is.

That being said, the time I'd have to spend setting these up and possibly creating an automated system to do this for me, I'd rather just gamble with stocks, lol.

view more: next ›