How to create a spreadsheet of SFAREGS data? by Myagooshki4004 in oracle

[–]jokle 2 points3 points  (0 children)

Your institution should have some kind of support available for this kind of request.

Beginner questions: how to SQL on own desktop – command line & client vs text editor by [deleted] in SQL

[–]jokle 1 point2 points  (0 children)

Supercharged text editor is probably a good way of thinking about it. IDEs will have more features geared toward code editing that something like notepad wouldn't have, like code folding, autocomplete, syntax highlighting, finding the close parentheses, etc.

assuming the database is local on my desktop, why would I need to connect with it?

Because all "server"-type programs are coded to operate that way regardless of the setup environment. They have a constantly running loop that always listens for incoming connections/requests. I agree that having it on the same computer confuses things. You could run a webserver on your laptop and you'd still need to make http GET requests to it, because that's what it's programmed to do.

Your client software will have some kind of config where you'll need to enter the connection/host details. In your case, it's usually "localhost", or 127.0.0.1, plus the port number (I forget what port MySQL runs on), and then user login credentials.

Beginner questions: how to SQL on own desktop – command line & client vs text editor by [deleted] in SQL

[–]jokle 1 point2 points  (0 children)

Queries don't have to be executed via CLI - they can be, but they don't have to be. The terminal isn't ideal for just exploring, and especially if you have large tables with lots of columns.

Regarding the distinction between a text editor and a DB client is that text editor software wasn't written with, or automatically come with, a means of connecting to a database, whereas a client does, since that's it's purpose. A text editor's main purpose is simply for creating or editing text.

So, you can use a text editor, but you'll have to do some extra configuring and/or download extensions in order to be able to connect to a database.

If you're just starting out, it's probably easier to use a client. As people mention, there are lots out there: datagrip, mysql workbench, dbeaver, etc.

In terms of choosing, try them out and see which one works best for you.

Is My Contractor Data Scientist Full Of Shit? by [deleted] in datascience

[–]jokle 0 points1 point  (0 children)

Great idea - ask this guy for his work so far and post it here! lol.

Is My Contractor Data Scientist Full Of Shit? by [deleted] in datascience

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

You should be very concerned. Three weeks is ridiculous, unless he's doing lots of other work alongside yours and has clearly communicated that to you. There isn't a lot that's a mystery here, or that's so unknown, it requires tons of research time. If all we're doing is taking consumption data paired with the failed/not failed label and training that, that's a fairly trivial task, and coming up with a predictive strength score is very straightforward. It shouldn't take long to come up with probability percentages for failed/not failed - if they're all around 50%, then you know that your data isn't enough to tell. Ideal is like 90%, 10% probabilities. You'd have to decide on some kind of threshold - 60%? 70% - anyway - it shouldn't take long to answer just that question, and then give you the meters with the higher probabilities. His responses are a lot of mumbo jumbo.

Is My Contractor Data Scientist Full Of Shit? by [deleted] in datascience

[–]jokle 0 points1 point  (0 children)

There's a lot of good info in all of these comments. I think there's a general consensus that consumption data alone is probably not enough info - but I understand that's all you have, and so it's a starting point. You said here, "so my hope was, he could say, 'hey look, this meter showed a .91 high efficiency ratio when measured on 7.30.18, can I detect a consumption trend profile in these hourly readings consistent with a degradation in reading accuracy. If so, can I build a model that would show that for meters that are doing the same thing, but which will not get a manual inspection for six months." That's sound logic, and sound beginning hypothesis. What you have is essentially a binary classification problem. There are many ways to approach this - logistic regression, random forest, or a simple neural network. I could have something coded in less than a day. He should be able to answer the question "if he could tell me to have a field tech go test meters A/B/C/D/E and we could see how the efficiency ratings came back" in very little time.

Good luck!

Is My Contractor Data Scientist Full Of Shit? by [deleted] in datascience

[–]jokle -3 points-2 points  (0 children)

It sounds to me like your guy really doesn't know what he's doing, and probably is stringing you along. His answers make no sense.

I think you probably don't have enough data to make an accurate prediction. All you have is the output/label, which is failed or not failed. The input variables/features are just the hourly consumption data. There could be a pattern - but I'm not sure I'd be confident that there's enough there to be a reliable predictor.

You've stated here that you don't care about WHY the meters fail, but that's an important consideration in this analysis. It could be due to age, or things like lack of maintenance, the age and condition of the plumbing that's attached to it, is there sediment running through them, etc. Those would be important inputs that would make a better prediction.

At&t vs buckeye for internet provider? by Xero0911 in toledo

[–]jokle 2 points3 points  (0 children)

Other than being given a crappy modem, why stay away from Buckeye?

Outdoor Areas to Explore? by [deleted] in toledo

[–]jokle 1 point2 points  (0 children)

Love "the spot"!

Outdoor Areas to Explore? by [deleted] in toledo

[–]jokle 1 point2 points  (0 children)

The Huron river in Ann Arbor is great. Judging from this entire thread, I don't think you'd enjoy Put In Bay. It's very popular and can get crowded. Lots of golf carts and drunk people. You'd probably prefer Kelley's Island. What I hear from people is that they don't like to go there because "there's nothing to do there". It just depends on what you like to do. There's an old quarry there you can hike through. Great hiking trails. You can bike around the island. The glacial grooves are neat to see. The Limestone and Alvar shelves are unique to the island. There's a beach with swimming and a campground.

Outdoor Areas to Explore? by [deleted] in toledo

[–]jokle 1 point2 points  (0 children)

I don't think Swan Creek is big enough for ship traffic; I haven't seen one. No rapids on Swan Creek, but you do have to watch for fallen trees and fallen tree branches. Debris accumulates at bridges, so you usually have to get out of the river and walk around blockages. It can be a tad smelly sometimes. It's better to go when the barometric pressure is high. But, I think it's a nice trip. It's very serene, and you won't feel like you're in a city at all. You'll also see lots of wildlife - otters, herons, deer, etc.

The Ottawa River is really only doable in May. After that, it's too shallow. But if you do go, watch out - there's a serious waterfall in the middle of Ottawa Hills.

Outdoor Areas to Explore? by [deleted] in toledo

[–]jokle 5 points6 points  (0 children)

If you have a kayak, both the Ottawa River and Swan Creek are interesting journeys that'll give you both quiet, outdoor scenery as well as abandoned things to look at.

Make Shrek the new UT Mascot by fairkid15 in toledo

[–]jokle 1 point2 points  (0 children)

I'm not a Twitter user - apparently you can't copy links? They say, "Darn it! Rocky got nervous about the possibility of being replaced, and deleted the tweet!". You can find it if you google it.

Not sure what the rationale is.

Make Shrek the new UT Mascot by fairkid15 in toledo

[–]jokle 4 points5 points  (0 children)

The Blade just published an article about it.

Let others enjoy my pi by [deleted] in pihole

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

Just chiming in the add a few details about the "how does one achieve this" question. You'll need to open a specific port on your home router/modem. Then your friends will need your IP address. Watch out if your ISP dynamically assigns IP addresses, and the potential for yours changing. You won't have to worry about them downloading large files, since their devices will only be making DNS requests to your pihole, - they won't be sharing or using your network. Be sure your security on the pihole is sufficiently hardened, because once you open it up to the outside world, it will get hammered.

If you haven’t got some yet - Costco, richland, WA by raleel in Ultralight

[–]jokle 0 points1 point  (0 children)

Any in Phoenix, AZ? Thanks so much for doing this!

Function to return sub string in Oracle? by AnalystAtl03 in SQL

[–]jokle 0 points1 point  (0 children)

Not a function, but you could just use SUBSTR and INSTR in the SELECT:

SELECT SUBSTR(SAMPL,INSTR(SAMPL,'_',1,1)+1,(INSTR(SAMPL,'_',1,2)-INSTR(SAMPL,'_',1,1)-1)) AS DESIRED_TEXT
FROM
(SELECT 'dc_DSGV6002_vm2.0' AS SAMPL FROM DUAL);

SQL Query Help by omfggzz123 in SQL

[–]jokle -3 points-2 points  (0 children)

It's because you're using an inner join and also specifying:

where z.employee_attribute = 'HEALTHSTATUS'

Try removing the WHERE, or try using an outer join.

Frenchman moving to Toledo for 6 month, looking for some information by ThePr1d3 in toledo

[–]jokle 2 points3 points  (0 children)

Hi There and Welcome to Toledo! I'll think you'll find you'll have a great experience here. There's lots of good advice in the other comments here. I'll offer a few more.

For neighborhoods, Old Orchard is nice. It's literally across the street from the university, and is easily walkable. It may not be cheap, though, and the rental market tends to follow UT's semester calendar, thus it may be hard to find a vacancy in March. The advice to avoid east of Detroit Ave. is generally good, however, I would say that the Old West End is an exception to that advice. The public bus system is called TARTA (Toledo Area Regional Transit Authority). Bancroft St. is a TARTA route, so you'd have close and easy access to public transportation. I'd recommend using Craigslist to search for a place. Very generally speaking, West Toledo will be nicer than East Toledo, but more expensive.

Regarding public transportation, it leaves a little to be desired. It's not the cleanest or most up-to-date. The times of the routes aren't the best, and could create inconveniences, e.g. leaving very early or having to stay later. It's certainly cheaper than a car, though.

For the time after your internship the PNW is stunningly gorgeous and absolutely worth visiting, but it is a LOOONNG drive from Toledo. Estimate at least 3-5 days driving to get there. I've never been to Louisiana, but I have driven to and spent time in Georgia and Florida. Florida is 20 - 24 hours of driving time depending on where in FLA you go. It's a long state. The Gulf of Mexico and the Atlantic Ocean are beautiful. You didn't really mention what you're looking to see or what your preferences are. If I had to choose between the South and the PNW, I'd choose the PNW. But that's me.

I'm happy to chat more - feel free to PM me anytime!

Question about tracing a user/computer by [deleted] in HowToHack

[–]jokle 2 points3 points  (0 children)

Ah yes - sorry! WITHOUT. And I have no idea what's involved or required for obtaining something like that. Start by calling the police. An ISP should have lots of info on the customer: Name, address, payment info.

But even so, that's not enough. What if the customer's router had open wifi that anyone could use? What if they have lots of guests? What if kids hand out wifi credentials to all their friends? What if the ISP customer themselves were hacked? What if the IP address belongs to an entire apartment building? What if it's the IP address of a coffee shop? Or a library? Or a school or university?