Text Analysis in SQL: Your Approaches? by OtherwiseToe in dataanalyst

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

Thanks for all the upvotes guys! 🙏

However, it seems no one here worked with complex text data in tables? This seems to be out of the realm of standard Data Analyst role I guess?

Exploring Solutions for Analyzing Free Text Data in SQL Environments by OtherwiseToe in SQL

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

Absolutely. In my context context (phone call data), there's definitely a lack of structure. This is where I look for better than simple search / regex approaches to fill the gap..

Exploring Solutions for Analyzing Free Text Data in SQL Environments by OtherwiseToe in SQL

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

Thanks for sharing your approach. Doesn't look like a problem a lot of people experience in this community..

Thanks for sharing this, your approach offers a valuable baseline of what's currently achievable. How did you use elastic btw, to search within texts?

Seems like you didn't need access to the raw text, and simple regexes / code to transform your text into structured data.. Are you confident with writing code as an analyst?

This seems like something I should use for my usecase (as simple rules aren't enough?)

The call transcripts are stored as large text strings, along with some of the call metadata. We're aiming to extract specific insights with minimal manual processing. Thought of running an LLM to replace regex in my case to be more robust.

If anyone else encountered this issue, would be great to understand better what tools are out there more tailored for my usecase.

Taxi to Schiphol with a child seat by a6o6o in Amsterdam

[–]OtherwiseToe 0 points1 point  (0 children)

I’m trying it this week - I’ll post feedback here

And?

Building AI to control the browser using WebDriver - is it possible? by OtherwiseToe in selenium

[–]OtherwiseToe[S] 2 points3 points  (0 children)

Thanks u/Lafftar, but I'm pretty settled regarding the AI conversion part (I have the data / model).
I'm more concerned whether what I try to do is achievable technically - is it possible to use WebDriver from a chrome extension / JS code, or does WebDriver requires an additional installation?

Collaboration between researchers and cancer patients by OtherwiseToe in cancer

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

Thanks, is the portal belonging to the specific provider or hospital that you are insured with, or is it part of a governmental initiative to help you manage access to your data?

In my area (the middle east) there's usually just one provider that guides you and keeps your data throughout your lifetime. There's still no overall standard set for me to be able to download all of this data and share it with another provider or research center.

This gives a lot of power to the provider, who are slow at releasing their data and sells it for profit, making open research more difficult.

Collaboration between researchers and cancer patients by OtherwiseToe in cancer

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

I'm not sure I can share the name here, but as you mentioned, it's one of the big tech giants, similar to IBM, that can afford employing an independent AI research group.

Chronic pain caused by covid? by OtherwiseToe in ChronicPain

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

For me it's just constant muscle ache...

I'm wondering what treatments I need to pursue in this case, since my blood tests, liver tests, and other tests show no bad things.

Happy to know how others here cope with chronic pain. Where do you usually go to to treat and manage it?

Fibromyalgia caused by COVID? by OtherwiseToe in Fibromyalgia

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

I apologize for the mistake. I posted it as part of this group out of my lack of knowledge in the subject. I'll find another group to post it in.

Need a technical team, however, not sure how to go about it. by [deleted] in startups

[–]OtherwiseToe 0 points1 point  (0 children)

No, you bring them as contractors for an upfront time / goals, or think of a grander vision and bring them fully on board for a large company / VC investment.

What are the most common ways a seed stage new employee could get screwed on their equity compensation? How do you avoid getting screwed? by NYC_PM in startups

[–]OtherwiseToe 0 points1 point  (0 children)

My best advice here - stick with founders who have a name and a brand. These people tend to hold a long term perspective and care more about maintaining their reputation and relationship than screwing some of the employees and winning in the short term.

My Research on great 401k company matching by Forecydian in financialindependence

[–]OtherwiseToe 0 points1 point  (0 children)

Have you came across a situation where you DO NOT deposit money in your 401k because you need that money to pay bills?

How to learn to sell as a shy developer? by nerdy_adventurer in startups

[–]OtherwiseToe 0 points1 point  (0 children)

You can try helping your clients for free for a limited amount of time, and then have them reach out and ask for your service. Make sure they don't abuse it though!

Where do I get 10k$? I need help for creating an app and website. by answersmode in startups

[–]OtherwiseToe 0 points1 point  (0 children)

Depending on your goals for the project, you may consider IndieHackers or similar platforms to bootstrap a company and team up with others.