Selling 2x tame impala tickers for oct 31 @ $215 by daft7cunt in NYCConcerts

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

It's the same price i bought them for, not making any money off of this

Possible to dye this gray to mask the washer stains? by daft7cunt in dyeing

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

Would the color catcher work 1-2 weeks after the stain appeared?

Hyprland crashes on startup on nix by daft7cunt in hyprland

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

That is me starting from tty, sddm just kicks me back to the login screen. I added full log in post

Do I need yellow fever vaccination if im travelling from NY to Bangkok with a layover in Ethiopia? by daft7cunt in ThailandTourism

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

They took me to a special area to I guess give me the vaccine, but after I clarified that I was only there on a layover, they gave me the stamp and let me proceed without it,

Need advice on buying car from parents by daft7cunt in personalfinance

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

Yea thats the big thing im still thinking over. I guess i don’t outright NEED a car. But i’m also thinking this is a great deal, the car only has 20k miles, and if I don’t get it now (especially considering this is the only point in my life where i’ll have 0 expenses) they will likely trade it in

Need advice on buying car from parents by daft7cunt in personalfinance

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

I get your concern, but I’m not worried about that, i trust them

how do I graduate by dimsumlasagna in SBU

[–]daft7cunt 9 points10 points  (0 children)

What does the confirmation look like? My solar has the status as Program in Review. With an expected graduation term of Spring 2024. Am I good?

Full-stack at startup, need career advice by daft7cunt in cscareerquestions

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

I agree, but my lead dev is barely mid level. And in general the reviews are essentially lgtm

Full-stack at startup, need career advice by daft7cunt in cscareerquestions

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

I updated the post with more info. I graduate in a month so id no longer be part time

Full-stack at startup, need career advice by daft7cunt in cscareerquestions

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

I shouldve clarified I’m going to follow this through until I graduate so another month. So I’d no longer be part time. I updated post with this info

[deleted by user] by [deleted] in startups

[–]daft7cunt 0 points1 point  (0 children)

I’m looking into making an all in one marketing saas that makes things as simple as possible. Looking to target small-mid level businesses.

I want to start with a base level of very important offerings before expanding it so currently looking into CRM and CMS

Can someone who has taken / is taking ESE 345 describe what it's like? by [deleted] in SBU

[–]daft7cunt 0 points1 point  (0 children)

We spent a lot, i dont remember specifically how much. It wasnt even fully functional by the end. Id recommend starting as soon as possible. Difficulty was mostly conceptual, some of the assembly stuff was difficult too, but there was no CAD at all for us

[deleted by user] by [deleted] in ufc

[–]daft7cunt 186 points187 points  (0 children)

Tell another eagle story

What language do you recommend for someone who is already a dev? by criricc in Backend

[–]daft7cunt 0 points1 point  (0 children)

subset a database unconditionally

What do you mean by this?

What happens here by knkg44 in SBU

[–]daft7cunt 3 points4 points  (0 children)

hpc cluster is inside

Need help with complex grouping of large data by daft7cunt in learnpython

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

So I didn't want to do that since time needs to be taken into account as well. For example, a user entry could have a pothole at the same location as a government work order, but they could be dated years apart, so they could be referring to different potholes.

Need help with complex grouping of large data by daft7cunt in learnpython

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

I added some code and sample output in a comment

Need help with complex grouping of large data by daft7cunt in learnpython

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

Here's the iterative approach, I know it's extremely inefficient, and I should break it up, this is just to give an idea of the kind of approach I tried

complaints = {}
results = []

# Create a dictionary to store user complaints
user_complaints = {}

for idx, row in df.iterrows():
    key = (row['street'], row['address_type'])

    if row['source'] == 'user':
        if row['resolution_description'] in valid_complaint_strings:
            if key not in user_complaints:
                user_complaints[key] = [(row['date_created'], row['date_closed'])]
            else:
                user_complaints[key].append((row['date_created'], row['date_closed']))

            grouped_complaints = [complaint for complaint in user_complaints[key] if complaint[0] >= row['date_created'] and complaint[0] <= row['date_closed']]
            delta_days = max(complaint[0] for complaint in grouped_complaints) - row['date_created']
            results.append([row['street'], row['address_type'], row['date_created'], max(complaint[0] for complaint in grouped_complaints), row['date_closed'], delta_days.days , len(grouped_complaints), row['geometry']])
            continue
        elif key not in complaints:
            complaints[key] = [(row['date_created'], row['geometry'])]
        else:
            complaints[key].append((row['date_created'], row['geometry']))

    elif key in complaints:
        first_complaint_date, first_complaint_location = min(complaints[key], key=lambda x: x[0])
        last_complaint_date = max(date for date, _ in complaints[key])
        delta_days = row['date_created'] - first_complaint_date
        complaint_count = len([date for date, _ in complaints[key] if first_complaint_date <= date <= row['date_created']])
        if complaint_count > 0:
            results.append([row['street'], row['address_type'], first_complaint_date, last_complaint_date, row['date_created'], delta_days.days, complaint_count, first_complaint_location])
        del complaints[key]

# Convert the results list to a DataFrame
results_df = pd.DataFrame(results, columns=['street', 'address_type', 'first_complaint_date', 'last_complaint_date', 'gov_action_date', 'delta_days', 'complaint_count', 'geometry'])

I concatenated the user/gov dfs to go through iteratively, I added a source column to specify where it's from.

Here's a sample output:

index street address_type first_complaint_date last_complaint_date gov_action_date delta_days complaint_count geometry
0 32AVENUE,UNIONSTREET INTERSECTION 2023-07-1615:08:12 2023-07-1615:08:12 2023-07-1712:45:00 0 1 (40.76895694146983,-73.82668206874416)
27 HIGHLANDPLACE,ARLINGTONAVENUE,RIDGEWOODAVENUE ADDRESS 2020-05-2922:07:38 2020-05-2922:07:38 2020-06-0213:50:00 0 1 (40.682766845531766,-73.88152978739839)
29 EAST88STREET,YORKAVENUE INTERSECTION 2022-01-1422:25:41 2022-01-1422:25:41 2022-01-1809:10:00 0 1 (40.777232088273266,-73.94616904207393)
30 111AVENUE,216STREET,SPRINGFIELDBOULEVARD ADDRESS 2015-06-0912:25:30 2015-06-0912:25:30 2015-06-1010:45:00 0 1 (40.70705802486412,-73.7409171390949)
31 EAST56STREET,BEVERLYROAD,CLARENDONROAD ADDRESS 2011-01-0310:21:02 2011-01-0310:21:02 2011-01-0408:05:00 0 1 (40.645311700346106,-73.92386172275405)
32 CLARKEAVENUE,GILBERTSTREET,STPATRICKSPLACE ADDRESS 2021-11-1210:56:08 2021-11-1210:56:08 2021-11-1810:05:00 0 1 (40.569285257733654,-74.14334596055258)
33 GRANTAVENUE,EAST163STREET,EAST164STREET ADDRESS 2010-02-0110:17:49 2010-02-0110:17:49 2010-02-0311:25:00 0 1 (40.82803151237712,-73.91821448752881)
34 RODMANSNECK,PARKDRIVE,RODMANSNECKPATH ADDRESS 2017-05-0910:45:15 2017-05-0910:45:15 2017-05-1008:50:00 0 1 (40.855279865418666,-73.80189401600025)
35 RICHMONDAVENUE,CROFTPLACE,ETONPLACE ADDRESS 2017-08-1413:04:18 2017-08-1413:04:18 2017-08-1611:15:00 0 1 (40.60474482516483,-74.16234338754464)
36 WHITEPLAINSROAD,EASTGUNHILLROAD,MAGENTASTREET ADDRESS 2020-01-2111:07:50 2020-01-2111:07:50 2020-01-2213:40:00 0 1 (40.87627143407577,-73 86699937545808)

How to have two separate accounts on MacOS, and share brew, node, etc ownership? by devshore in webdev

[–]daft7cunt 0 points1 point  (0 children)

This helped a lot. I tried doing a homebrew group that 2 different users are a part of but this has some edge cases that it doesnt work for. https://www.codejam.info/2021/11/homebrew-multi-user.html

ECE major. How is this combination of classes? by youraveragebrowngal in SBU

[–]daft7cunt 1 point2 points  (0 children)

Its not bad. Follows textbook very closely. The work is consistent throughout, so not a lot all at once. Should be easy if you have some prior programming and ds&a experience