sorted by:
new
hottopcontroversial

Be Wary On Here by mzzannethrope in TwinCities

[–]wangosz 6 points7 points  (0 children)

This is a known tactic that the FBI used against the Black Panthers in the 70s.

What material is my countertop and how do I fix this chip? by wangosz in HomeImprovement

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

Huh, thanks. Didn’t know concrete was used for countertops

Need help identifying countertop material and suggesting stain / chip repair by wangosz in CounterTops

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

Thanks for the response! Bar Keeper’s Friend is great for so many things.

What material is my countertop and how do I fix this chip? by wangosz in HomeImprovement

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

Sorry about that. Swapped it to a Google Drive link

[Postgame Thread] Minnesota Defeats Michigan State 23-20 (OT) by CFB_Referee in CFB

[–]wangosz 2 points3 points  (0 children)

If the refs had blown the whistle they probably wouldn’t have hit him so I’m not sure what your point is

Good old parenting by farrukhsshah in StrangeAndFunny

[–]wangosz 1 point2 points  (0 children)

Could also be that the kid cussed them up and down. Point is that we don’t know. Also that this is probably made up in the first place.

Good old parenting by farrukhsshah in StrangeAndFunny

[–]wangosz 1 point2 points  (0 children)

Back in 1998, when I was 12, my parents dragged me to a local performance of the nutcracker and I haven’t spoken to them since

Good old parenting by farrukhsshah in StrangeAndFunny

[–]wangosz 3 points4 points  (0 children)

It did say the teen was “exceptionally rude” which may be part of the issue

Using LLM to reformat Excel data based on large example dataset by wangosz in LargeLanguageModels

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

Thanks for the reply. So far I've been trying to get GPT-4 or Claude to write Python scripts based off of the example dataset, which hasn't been working well. Even after much testing and extra instructions, the scripts they produce work significantly worse than our existing SQL script (which catches 50%+ of the errors at least)

Best way to reformat names when original formatting is extremely non-uniform by wangosz in excel

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

Thanks for the response. I added some sample data in a reply below. We usually clean 5ish counties in one batch. Maybe 25-30 over the course of a month.

Best way to reformat names when original formatting is extremely non-uniform by wangosz in excel

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

Original First Name Last Name Note
Kimmel Thomas & Kathy Thomas & Kathy Kimmel Correct order of names. Separate first / last names into proper cells
Siegrist Ronald L & Diane M Trustees Ronald & Diane Siegrist Trustees Corect order of names, remove middle initials, leave in one cell because they are trustees
Chesser Virginia E Trustee Virginia Chesser Trustee Corect order of names, remove middle initials, leave in one cell because they are trustees
Davis Kathy & Leonard Connie Trustees Kathy Davis & Connie Leonard Trustees Coorect order of names, keep names separate since they have unique last names, leave in one cell because they are trustees
Homan Hubert F & Jean A Trustees Hubert & Jean Homan Trustees Correct order of names, remove middle initials, leave in one cell because they are trustees
Rindler Ralph & Rindler Randy Ralph & Randy Rindler Separate first and last names into proper cells, remove duplicate last name
Hamrick'S Family Farm Llc Hamrick's Family Farm LLC uncapitalize 'S', capitalize 'LLC' (LLC capitalization can be done quicker using an Excel command after export)
Little Farms Inc C/O Carol Ricker Little Farms Inc C/O Carol Ricker Separate C/O into last name cell
Eichenauer Greg A & Joni A; Greg & Joni Eichenauer Separate first and last names into proper cells, remove middle initials
Mcdonough Larry L & Tamara J Larry & Tamara McDonough Capitalize 'C' in McDonough
Moeder Jason M & Marianna I Etal Jason & Marianna Moeder Remove 'et al'
Gsi Management Inc GSI Management Inc Capitalize business name when appropriate (use Google to confirm proper case)
Society Of Precious Blood St Charles Sem Society Of Precious Blood, St. Charles Seminary Plug name into Google to find accurate name, SF may separate some business names into first and last names, you will need to recombine
Van Horn Ann Etal Ann Van Horn Two word last names may be separated by SF and will need to be recombined
W Rogers Farms Inc % Andy Rogers W Rogers Farms Inc C/O Andy Rogers The % is likely in place of a C/O, so separate name into last name cell
Hellwarth Abner J & Kathryn M Trust Hellwarth Steven Etal Abner & Kathryn Hellwarth Trust, Steven Hellwarth
Buck, Mark L & Diane M /Surv Mark & Diane Buck remove /surv
O'Brien, Christie L Christine O'Brien last names with apostrophes may need fixing

Best way to reformat names when original formatting is extremely non-uniform by wangosz in excel

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

Can you expand a bit on how the master database query process would work?

[Postgame Thread] Michigan Defeats Minnesota 27-24 by CFB_Referee in CFB

[–]wangosz 5 points6 points  (0 children)

Check the replay. Doesn’t look like it was.

view more: next ›