Data Guy

[Data Guy @data_guy_]

@rachel_l_woods For me the struggle is leveraging it for niche tasks like this too. In my case it was trying to solve for using R to do an API get request to capture data via a u iwye set of credentials from a crm. GPT struggled hard to get to a place to accomplish this like I do in python.

[Data Guy @data_guy_]

@DataSciencetut @rstatstweet Thabk for this. How can one do the reverse of this and read multiple sheets into separate df's at once? Thanks

[Data Guy @data_guy_]

Any server gurus out there in the world that can help me find out why I can't odbc to a vm set up as a domain controller from a remote pc? Thanks

[Data Guy @data_guy_]

@simonholdorf Can you tell me why I can't odbc to a vm set up as a dc from a remote pc, plz? I'll follow/retweet as much content as possible if you could help me resolve that, thank you.

[Data Guy @data_guy_]

@kccarrell Excel Power Query/Power Pivot. Big ROI there for effort to output vs. more technical tools like SQL/R/Python.

Simple cleaning methods in excel. Flashfill, how to filter, conditional format duplicates, clean data vs. dirty data, filter formula, ctrl-t, ctrl-1,ctrl-g,ctrl-.

[Data Guy @data_guy_]

@daniela_witten I left a life of retail and hit the research hard for 6 months. I'm 3 months new in role and have the chance to experiment with both. I've Enjoyed R and have found it much easier to work with data than python. Python has been powerful for web based things though.

[Data Guy @data_guy_]

@DataJayInTech I use it as a copy/paste automation tool and data validation checker.

FILTER(), INDEX(),SEQUENCE(),IF(), and conditional format duplicate highlights with smaller data sets come I'm handy for fast filtering.

[Data Guy @data_guy_]

Any python aficionados willing to connect with me on a script I'm trying to accomplish for work?🙏 @realpython

[Data Guy @data_guy_]

@patilindrajeets Then reference old code and think, how the hell did I even figure that out? And why do I barely remember?

[Data Guy @data_guy_]

@patilindrajeets It's tough for me bc I'm an IC and no colleagues to lean on. Literally in the R trenches everyday just trying to survive. I love it, but every night on github reading through the vignettes, I realize I barely know anything. Only to get in the next day, forget what I already know

[Data Guy @data_guy_]

@rcrdleitao @souboaaolonge Sou Brasileiro Americano- Mas meu Portuguese eh muito ruim lol

[Data Guy @data_guy_]

@rcrdleitao @souboaaolonge Dude you're brazilian?

[Data Guy @data_guy_]

Get total occurrences based on exactly 15 number in sequence

Anyone have a solution on this one?

https://t.co/HwPO9QwPYI

#RStats #rstudio #datafam

[Data Guy @data_guy_]

Shout out to @rcrdleitao for assistance in my young journey and to @Alex_TheAnalyst for being the 1st source of inspiration when I began my DA curiosity on YouTube. Still a massive way to go, but one small win at a time. The community over all has been great. #datafam

[Data Guy @data_guy_]

So far I've reduced manual work by 10 hours a week and ensured a higher level of accuracy with R coding. As a DA new in role with little prior experience, I think that's something to celebrate! I can say - stay persistent, and keep tinkering. If I can do it - anyone can

#rstats

[Data Guy @data_guy_]

@Alex_TheAnalyst I see massive opportunity with the way we handle our data and I want to get down and dirty with it but then I start venturing into DB dev/engineer territory and I'm like wait, what?

[Data Guy @data_guy_]

@Alex_TheAnalyst But yeah most the time so far I just feel nervous that the core work isn't what I need to be practicing for long term goals. I've automated some of the manual work with R and Excel. No idea if the focus is right but it's all I can handle. R alone is overwhelming

[Data Guy @data_guy_]

If I get an ACCESS DB error 3217 on a failed INSERT INTO query because header name doesn't match, what can I do when the verify the data is correct? It seems to still have that data in the query from when the excel file was incorrect. Is there a way to refresh scripts? #Microsoft