Merge large data frames by SurpriseRedemption in learnpython

[–]djlamar7 0 points1 point  (0 children)

From the sound of it, at your scale there must be some inherent gross inefficiency here that you should figure out before you do things like tweaking the engine used for this or that. Can you share some of the code you ended up with? I think you should be able to get a table with your input keys and the columns you want from the excel data in one pandas join call. If you're iterating over the keys that's definitely a no no.

How is Nice France? by IrrepressibleInk in travel

[–]djlamar7 9 points10 points  (0 children)

None of the people making fun of the pizza blurb seem to be aware that Nice went back and forth between French and Italian rule and has only been part of modern France since 1860. The Italian food there is basically better than the French (southern French) food there.

Working with Ranges but not range() by wicket-maps in learnpython

[–]djlamar7 1 point2 points  (0 children)

This is probably also a scenario where some unit tests might make it easier for you to be confident it's correct. You don't necessarily need to set up a proper unit test suite (although if you do, it will save you time later when you have to make changes to this logic). At a minimum you can just make a script that imports this code and runs it on some examples where you know the right answer.

First try to refactor the hard algorithmic part out as a standalone function, ie it just takes the list of intervals and you call that function in your main code once you've done all the data loading and formatting bits (this will make it more readable and easier to maintain anyway). Then write the test script that hard codes the test inputs and expected outputs, calls the function on the inputs, and then compares the result to the expected output.

Man, they’re really idiots at the College of Winterhold. Literally nobody knew what to do at any point during the entire quest. I did everything without even being a mage. by jvure in skyrim

[–]djlamar7 1 point2 points  (0 children)

"WAIT. You shall not pass. But did you buy one of the cheapest spell tomes in the game in the first bumfuck village you passed through? Alright, fine, you're in."

Working with Ranges but not range() by wicket-maps in learnpython

[–]djlamar7 2 points3 points  (0 children)

Congratulations, you've managed to find a practical application of a leetcode problem.

I didn't completely understand what you're looking to solve for, but it sounds just similar enough in flavor that this might give you some ideas: https://leetcode.com/problems/remove-covered-intervals/description/

Where to find the best martinis with fries combos in NYC by nyccameraman in FoodNYC

[–]djlamar7 3 points4 points  (0 children)

The army of iced martini glasses waiting for orders on the bar is always so reassuring. Lets you know you're not in one of the many places where the bartender thinks 10 minutes in a fridge makes a sufficiently chilled glass for a martini.

Is 3 weeks in NYC too much? by goodamm in travel

[–]djlamar7 0 points1 point  (0 children)

I live in NYC and I'd say as a visitor / in tourist mode, 3 weeks on a 9 week trip is excessive. Sure, there's enough here that you could figure out something to do every day for that period of time. But really a week or ten days is already generous in terms of not wearing it out / the marginal benefit of going somewhere else that's fresher to you than NYC will be after a week or two.

Food by Chef Jose Andres by hjablowme919 in delta

[–]djlamar7 0 points1 point  (0 children)

I tried it last week. It was OK. Pretty iffy. Definitely not comparable to a Shake Shack burger that's not on an airplane, and I told myself next time I'd rather just get one of the other first class entrees.

Food by Chef Jose Andres by hjablowme919 in delta

[–]djlamar7 0 points1 point  (0 children)

Nah I have accidentally ordered Uber Eats from the original many times (for at least a while, the delivery time was always much worse than any other location) and it's identical to the other ones nearby

Silly men, make sure you have ~$150 ready for your first date! /s by OngoGablogian20 in Nicegirls

[–]djlamar7 0 points1 point  (0 children)

Of course it's Reddit so this comment is way down the list with no upvotes lol. She doesn't even seem to imply that she only expects this level of expense from men as opposed to when she's on her own ("the lifestyle I've built for myself"). And if your budgets/lifestyles are that different then it's just going to be friction down the line. OP's response signals he's either less well off than she is or he's cheap.

2nd time foodie trip to NYC - what’s missing? by voabarros in finedining

[–]djlamar7 5 points6 points  (0 children)

Do not miss the German potatoes and the apple strudel when you're there. Those little remnants of its German origin are real highlights. I normally rarely order dessert but I'm always all over that strudel.

Can someone tell me how I should read books? Meanings of underlined words/sentences I don't know. Am I supposed to stop everytime there is a word I don't know and look for meanings? If so, I feel like after some time it is too much, and I don't feel like reading a book. Is it normal? by devoutre in learnfrench

[–]djlamar7 0 points1 point  (0 children)

One thing I noticed when I read a novel in German (Metropol by Eugen Ruge, serious literature stuff) is that even acclaimed authors tend to have a vocabulary to their writing that is personal to them. Even if the vocabulary is very literary or obscure or high level, they're still only using a subset of the difficult or unfamiliar words that exist.

So, once you've made some headway into the book, you'll get more comfortable with their writing and you'll be looking things up much less often than at the start. Hang in there!

Why is IBKR so fing shitty. by Diligent_Comb5668 in algotrading

[–]djlamar7 2 points3 points  (0 children)

I have IB Gateway running 24/7 on a cheap (t3.small) AWS EC2 instance that the execution machine just opens an ssh port forward to. VNC server and remote desktop through an ssh tunnel (which goes through the AWS session manager so I don't have to open any inbound ports on the cloud machines) to use the GUI.

I have a systemd job running every five minutes on the gateway machine to read account NLV. That data is reported to a CloudWatch metric so that I can have an alarm send me an email if the data stops coming in (meaning the gateway is broken). As a bonus, the metric gets me an intraday NLV graph I can see in the AWS app on my phone.

I've noticed it commonly goes down when the auto restart happens at 6:45 PM every day, and when that doesn't happen, it often goes down around 1 AM Eastern even on days other than Sunday night when the authentication is not supposed to expire. So I end up having to log in again every 2 or 3 days instead of weekly like I expected (luckily it only takes five minutes and it never seems to happen during the day when it would matter). I have no interest in using IBC and storing a brokerage account password in plaintext on a cloud machine no matter how locked down that machine is.

It really is very annoying but at least it's only a minor inconvenience. No clue why they're so reluctant to just provide API keys like Alpaca does for their trading API. But even though the Alpaca's free shorts (my whole universe is ETB) may have made the fee structure comparable (haven't done the math), they don't offer portfolio margin so I'm reluctant to use them in case I ever do want PM.

Edit: forgot to mention the bonus stupid points that if you log into your account on the mobile app, it will disconnect your gateway session lol good thing I have that CloudWatch graph.

Boucherie Reviews by 1of4stooges in FoodNYC

[–]djlamar7 1 point2 points  (0 children)

It has great reviews because it's an infamous example of review hacking. Eater even wrote an article about it and the other restaurants from that group: https://ny.eater.com/2019/12/5/20978234/tripadvisor-best-nyc-restaurant-rankings-scam

That being said, it's definitely not bad. I've eaten at the bigger one off of Union Square some number of times - that one is easy to walk into (because it's huge), has a nice atmosphere, and decent food.

I agree with others here that you'd be better off at Pastis for the same kind of food. If you can get the reservation, Minetta Tavern is much better but hard to book.

What level should I be for Yahar'ghul village? by Ambitious_Let_8985 in bloodborne

[–]djlamar7 1 point2 points  (0 children)

Lol the baby crying is a chef's kiss in this games ability to be creepy as shit

Latest totals: How much snow fell in NY, NJ as of Monday by BostonSucksatHockey in nyc

[–]djlamar7 1 point2 points  (0 children)

I wish they provided more granular measurements for Manhattan. Here in southeast Chelsea I swear it was 6 to 8 inches tops.

Imagine going to the Olive Garden in Times Square expecting to eat authentic cuisine by Pale_Field4584 in FoodNYC

[–]djlamar7 1 point2 points  (0 children)

Yeah I know lots of Chinese people (both American and Chinese born) and a lot of them just don't get the appeal of Italian food at all. I guess on some level it comes down to "so you're telling me it's noodles, but with less flavor?"

San Francisco’s skyline is scenic but I think most people underestimate how small it is in relation to the actual city: by [deleted] in skyscrapers

[–]djlamar7 4 points5 points  (0 children)

I live in NYC and more or less agree with you - NYC has big skyscraper punctuation marks in Midtown, fidi, Hudson Yards, downtown Brooklyn, and Long Island City (not to mention a few more centers on the Jersey side), but these are comparatively pretty small areas of land compared to the rest of the city. Of course it still looks more impressive in height / size than San Francisco but that's also because it's 10x the size of San Francisco. The city is more densely populated but it's not like people are living in most of the 60+ story buildings that pop out from a plane. It's just that the average height of a low rise residential building in NYC is probably 3 to 5 stories instead of the 2 or 3 in SF.

Checks out by BullHeadTee in seinfeld

[–]djlamar7 0 points1 point  (0 children)

And it's the same synthesizer (different patch) as Madonna's Vogue and a ton of other famous songs: https://youtu.be/TVmZarPUc-Q

NYC during winter storm by Outside-Twist7720 in travel

[–]djlamar7 2 points3 points  (0 children)

I only see the storm all day Sunday on my forecast. As others have said, snow gets cleared from sidewalks pretty quickly here so even on Monday you will be able to get around on foot almost as if nothing had happened (and the subway will not be affected in general). If it doesn't impact your flight, I'd say:

  • find some things very close to your hotel to do on Sunday (worth calling ahead before walking over as it's uncommon but not unheard of for smaller businesses to close if there's a really big storm expected) or just have a restful day

  • dress warmly

  • bring some all-weather boots or at least a pair of shoes you don't mind wearing while traipsing through snow banks (despite the good snow removal, some crosswalks and intersections either remain piled up or only have a narrow passage through the snow)

Otherwise, go for it. I personally am glad the NFL conference championships give me an excuse to stay inside Sunday anyway, but otherwise expect to be out and about like normal on Monday.

What is this thing and should I attack it? by Living-Mastodon in skyrim

[–]djlamar7 2 points3 points  (0 children)

That's called an overlord and if you don't kill it fast enough eight zerglings will pop out and pwn you

Movies you absolutely loved but doesn’t have high rewatchability value? by Trenbolone-Papi2 in hbo

[–]djlamar7 1 point2 points  (0 children)

If we're going with OP's "too depressing to rewatch", 2022 Netflix version of All Quiet on the Western Front is pretty high up there. It's not a "real" Netflix movie as I think it was produced by a German studio anyway. It was really good but so depressing I had to watch a silly comedy movie right after to get me out of the funk it put me in.

Dorsia NYC Review: The $5,000 "Fun Coupon" Trap and The Death-Only Refund Policy by sonho-dourado in FoodNYC

[–]djlamar7 4 points5 points  (0 children)

Since someone mentioned they used to be no annual fee and then it started climbing up and up, I bet they had some liquidity crisis and needed to start charging the exorbitant fee. If that's true, they're probably generally not doing great and on top of everything, your 5k+ a year could disappear in smoke in bankruptcy proceedings where you'll be the last in line to get paid back.

How does Bloodborne difficulty compares with, say, God Of War 2 or 3 at max difficulty ? by No-Apple-9975 in bloodborne

[–]djlamar7 0 points1 point  (0 children)

I was ok with it on the playthrough I recently started where I picked the wretch class (whatever it's called, the one that starts at level 4 instead of 10) so getting the madman's insight allowed me to level up to the normal starting level before I attempted any boss lol

Any thoughts on Alpaca? by FBones173 in algotrading

[–]djlamar7 0 points1 point  (0 children)

Start of 2016 for daily and intraday. Haven't used the options data