@stevensanderson@mstdn.social
@stevensanderson@mstdn.social avatar

stevensanderson

@stevensanderson@mstdn.social

New Book: https://packt.link/oTyZJ | R - install.packages("healthyverse") | #SQL | opinions are mine | #rstats | Mainly though my wife and kids :) | Advisor to DoTadda - All posts delete in 12 months.

This profile is from a federated server and may be incomplete. Browse more on the original instance.

stevensanderson, to Excel
@stevensanderson@mstdn.social avatar

This VBA macro saves an Excel worksheet as a PDF. It sets and sorts the data, creates a temporary sheet with headers, formats and aligns the data, and adjusts column widths. The macro defines the PDF path, deletes any existing file, sets page orientation and footer, exports the sheet to PDF, deletes the temporary sheet, and shows a message with the PDF path. Modify to your needs if you find it useful.

stevensanderson, to random
@stevensanderson@mstdn.social avatar

The newest version of my #R TidyDensity really took off for me. Now wait until the next release which introduces 39 new functions. #R

stevensanderson, to medical
@stevensanderson@mstdn.social avatar

DNFB for medicine is discharged not final billed and is used a lot at hospitals as it represents the AR not yet billable. It is important to keep this to a minimum of days for efficiency and ability to get paid. It affects cashflow, so the lower the better. I wrote a quick diddy that sifted 147mllion rows in 2 seconds to give me my average dnfb by AR snapshot month

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

If you work with text data in R, the gregexpr() function is essential for pattern matching. It finds all occurrences of a pattern within a string. Key parameters include pattern, text, ignore.case, perl, fixed, and useBytes. You can match characters, ignore case, use advanced regex, and search fixed strings.

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-05-17/

image/png
image/png

stevensanderson, to random
@stevensanderson@mstdn.social avatar

39 new functions coming to my #R package TidyDensity at it's next release which will be soon.

#R

https://www.spsanderson.com/TidyDensity/news/index.html#tidydensity-development-version

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

🎉 New Post Alert! 🎉

Counting words in a string is a fundamental task in data analysis.

  1. Base R: Use strsplit(), a straightforward method to split strings and count words.

  2. stringr: The str_split() function from the stringr package makes the code more readable.

  3. stringi: For powerful and efficient string manipulation, stri_split_regex() from the stringi package is your go-to.

Happy coding! 🚀

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-05-16/

stevensanderson,
@stevensanderson@mstdn.social avatar

@damien_dupre yes that works too

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

#R #RStats #rprogramming #Programming almost ready

video/mp4

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

After I update my #R Package TidyDensity there will be 176 functions...that's a lot of code I wrote. This is just a reflection. Right now it is 172.

#R #RStats #RProgramming #Programming #Coding #ROpenSci

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

🔎 Selecting Columns Containing a Specific String in R: A Quick Guide 🚀

Hey R users! Need to select columns by a specific string? Here's how in base R, stringr, stringi, dplyr, and with a bonus from data.table.

🆒 R
✅ grepl
📦 stringr
📦 stringi
📦 dplyr

Bonus: 📦 data.table
library(data.table)
df_price <- df[, names(df) %like% "price"]

Happy coding! 🚀

Post: https://www.spsanderson.com/steveondata/posts/2024-05-15/

#R

image/png
image/png
image/png

stevensanderson, to Finance
@stevensanderson@mstdn.social avatar

I have started a public team on my DoTadda account (DoTadda is great for portfolio managers specifically) that is for R stuff, you can find it here:

https://app.dotadda.io/teams/bad2fd50-1971-4103-903a-4c6406e3f445/dots

#R #RStats #Finance #PortfolioManagers

If you are looking for a great way to automate knowledge search, share and the like you can use this to book a demo: https://4fi3yk3dxbg.typeform.com/to/qv1Xd3Ae?typeform-source=www.dotadda.com

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

Want to check duplicate values across columns of a data.frame? Well you can do that in a basic way with TidyDensity and the check_duplicate_rows() function, or you can go through todays blog post for some other ideas with and

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-05-14/

image/png

stevensanderson, to gpt
@stevensanderson@mstdn.social avatar

The white background logo is the current hex sticker for my TidyDensity #R the others were generated from DALL-E pretty cool

image/png
image/png

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

Discover essential techniques to check for column existence in R data frames!

Use %in% with names() or colnames(), explore dynamic checks with exists() and within(), or identify patterns with grepl(). Experiment with these methods in your projects.

Post: https://www.spsanderson.com/steveondata/posts/2024-05-13/

#R

image/png

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

🔍 Quick Guide: Detecting Strings in R

In my latest blog post, I cover how to find specific strings in data columns using the str_detect function from the stringr package and base R functions. You'll see practical examples with both grepl for identifying matches and gregexpr for counting occurrences.

Read more here: https://www.spsanderson.com/steveondata/posts/2024-05-10/ and explore ways to make string detection a breeze in your data work!

#RStats #DataCleaning #R #RProgramming #Programming #Data #Regex

image/png

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

Learn efficient ways to collapse text by group in R! Explore base R's aggregate(), dplyr's group_by() and summarise(), and data.table's grouping. Mastering these techniques enhances data preprocessing skills. Try these examples with your datasets to optimize workflows. Happy coding! 📊💻

#RProgramming #DataAnalysis #R #RStats #Programming #Data

Post: https://www.spsanderson.com/steveondata/posts/2024-05-09/

image/png

major, to Economics
@major@social.lol avatar

Used car prices coming down in the USA. This isn't great for new car buying as dealers will offer less on a trade. Dealers still aren't moving much on new car pricing (yet).

#economics #finance

image/png

stevensanderson,
@stevensanderson@mstdn.social avatar

@major I think the e-buyers like carvana are trying to reverse that, but I say let the prices fall, cars are not assets and honestly the whole covid no production thing is over

stevensanderson,
@stevensanderson@mstdn.social avatar

@major Yes people will be underwater on car loans, which sucks but I would say is typical, cars retain zero value, your underwater as soon as you leave the lot. I think the manufactures in their quest to extract as much money as possible from people have over inflated the price of cars and dealers made it even worse. For the life of me I can't understand why people are paying, I negotiated my and my wifes cars down tremendously, always prepare to walk out, cars get pumped out.

stevensanderson, to random
@stevensanderson@mstdn.social avatar

👍 In R, you can easily extract specific columns from a data frame by their numerical positions. For instance, to grab the second column from a data frame df, you can use df[, 2].

🙅‍♂️ You can also exclude columns by using negative indexing, such as df[, -2] to exclude the second column.

Keep exploring and happy coding!

#RProgramming #DataManipulation #DataAnalysis #R #RStats #Coding #Data

Post: https://www.spsanderson.com/steveondata/posts/2024-05-08/

image/png

stevensanderson, to random
@stevensanderson@mstdn.social avatar

I want to thank everyone who has downloaded one of my #R #Packages as the I have surpassed a combined 100,000 downloads of them!!

Thank you!

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

Counting NA's across columns in #R sure you can do that!!

My post today uses and to accomplish this

#R

Post: https://www.spsanderson.com/steveondata/posts/2024-05-07/

image/png
image/png
image/png

stevensanderson, to random
@stevensanderson@mstdn.social avatar

Today I am writing on the AIC functions available in my hashtag#R hashtag#Package TidyDensity.

There are many of them, with many more on the way. Some of them are a little temperamental but not to worry it will all be addressed.

My approach is different then that of fitdistrplus which is an amazing package. I am trying to forgo the necessity of supplying a start list where it may at times be required.

Post: https://www.spsanderson.com/steveondata/posts/2024-05-06/

#R #RStats #RProgramming #Statistics #Coding #Data

stevensanderson, to programming
@stevensanderson@mstdn.social avatar

working on the next release of TidyDensity

#R

stevensanderson,
@stevensanderson@mstdn.social avatar

@michaelten here you go https://github.com/spsanderson/TidyDensity #R #RStats #rprogramming #Programming #Coding #statistics

brodriguesco, to random
@brodriguesco@fosstodon.org avatar

What are some packages that take forever to compile?

stevensanderson,
@stevensanderson@mstdn.social avatar

@cedricr @brodriguesco nice! I have a 16 core laptop I’ll have to try this and see the difference

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • provamag3
  • thenastyranch
  • magazineikmin
  • InstantRegret
  • GTA5RPClips
  • ethstaker
  • Youngstown
  • everett
  • slotface
  • osvaldo12
  • rosin
  • mdbf
  • kavyap
  • DreamBathrooms
  • megavids
  • ngwrru68w68
  • Durango
  • modclub
  • cubers
  • khanakhh
  • Leos
  • tacticalgear
  • cisconetworking
  • vwfavf
  • tester
  • anitta
  • normalnudes
  • JUstTest
  • All magazines
    •