Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Search this Thread Display Modes
  #21  
Old 03-07-2018, 08:35 PM
AMedActuary AMedActuary is offline
Member
SOA
 
Join Date: May 2007
College: UCLA Alumni
Posts: 391
Default

For me, I've been using R anywhere I can. It's just turned into a one-stop shop for me. I can write SQL queries in RStudio and pull data from the data warehouse. I can join tables once I get data from the warehouse (using dplyr) and output to an Excel or csv file. If I want to make a report, I use Markdown to write up a report and make great looking graphs (using ggplot2) and tables and write up the report so it's all done in the same place.

I am training the rest of my team on how to use it but that will take time. I'd say the rest of my team uses Excel the most then probably SAS or Teradata or SQL Server to pull data from a database.

Last edited by AMedActuary; 03-07-2018 at 08:38 PM..
Reply With Quote
  #22  
Old 03-08-2018, 09:05 AM
ronaldy27's Avatar
ronaldy27 ronaldy27 is offline
Member
CAS
 
Join Date: Jan 2012
Location: 'Murica
Studying for the credential
Posts: 3,046
Default

Quote:
Originally Posted by AMedActuary View Post
For me, I've been using R anywhere I can. It's just turned into a one-stop shop for me. I can write SQL queries in RStudio and pull data from the data warehouse. I can join tables once I get data from the warehouse (using dplyr) and output to an Excel or csv file. If I want to make a report, I use Markdown to write up a report and make great looking graphs (using ggplot2) and tables and write up the report so it's all done in the same place.

I am training the rest of my team on how to use it but that will take time. I'd say the rest of my team uses Excel the most then probably SAS or Teradata or SQL Server to pull data from a database.
train me
__________________
Spoiler - for size:



Reply With Quote
  #23  
Old 03-08-2018, 09:27 AM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is online now
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 47,683
Default

Nowadays I use Spark, and sometimes R on Spark. But I mostly use either Scala or Python on Spark. The data are mostly stored on the cloud, either in Blob or MS SQL Database.

My current client project just has me using RStudio on a big CSV file. My department has currently taken a big interest in using H2O for the ML stuff.
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
  #24  
Old 03-08-2018, 09:36 AM
panther panther is online now
Member
 
Join Date: Feb 2009
Posts: 4,251
Default

Quote:
Originally Posted by AMedActuary View Post
For me, I've been using R anywhere I can. It's just turned into a one-stop shop for me. I can write SQL queries in RStudio and pull data from the data warehouse. I can join tables once I get data from the warehouse (using dplyr) and output to an Excel or csv file. If I want to make a report, I use Markdown to write up a report and make great looking graphs (using ggplot2) and tables and write up the report so it's all done in the same place.

I am training the rest of my team on how to use it but that will take time. I'd say the rest of my team uses Excel the most then probably SAS or Teradata or SQL Server to pull data from a database.
do you have any suggestions or resources that you used to learn R?
Reply With Quote
  #25  
Old 03-08-2018, 09:41 AM
Marcie's Avatar
Marcie Marcie is offline
Member
CAS
 
Join Date: Feb 2015
Posts: 8,289
Default

Quote:
Originally Posted by panther View Post
do you have any suggestions or resources that you used to learn R?
Yes.
Reply With Quote
  #26  
Old 03-08-2018, 11:01 AM
panther panther is online now
Member
 
Join Date: Feb 2009
Posts: 4,251
Default

Quote:
Originally Posted by Marcie View Post
Yes.
even charles shulz thinks your act is lame
Reply With Quote
  #27  
Old 03-08-2018, 02:16 PM
BassFreq's Avatar
BassFreq BassFreq is offline
Member
CAS
 
Join Date: Jun 2003
Location: Chicago
Studying for all eternity
Favorite beer: Duff
Posts: 1,708
Blog Entries: 2
Default

1) Outlook, 2) chrome
__________________
If at first you don't succeed, you have one data point.
Res ipsa loquitur, sed quid in infernos dicet?
Reply With Quote
  #28  
Old 03-08-2018, 02:18 PM
redearedslider's Avatar
redearedslider redearedslider is offline
Member
CAS
 
Join Date: Oct 2015
Posts: 13,359
Default

Quote:
Originally Posted by AMedActuary View Post
For me, I've been using R anywhere I can. It's just turned into a one-stop shop for me. I can write SQL queries in RStudio and pull data from the data warehouse. I can join tables once I get data from the warehouse (using dplyr) and output to an Excel or csv file. If I want to make a report, I use Markdown to write up a report and make great looking graphs (using ggplot2) and tables and write up the report so it's all done in the same place.

I am training the rest of my team on how to use it but that will take time. I'd say the rest of my team uses Excel the most then probably SAS or Teradata or SQL Server to pull data from a database.
This workflow intrigues me.
__________________
Quote:
Originally Posted by Abraham Weishaus View Post
ASM does not have a discussion of stimulation, but considering how boring the manual is, maybe it would be a good idea.
Reply With Quote
  #29  
Old 03-08-2018, 04:52 PM
Abelian Grape's Avatar
Abelian Grape Abelian Grape is offline
Meme-ber                         Meme-ber
CAS
 
Join Date: Jul 2014
Posts: 41,429
Default

1. Excel
2. SQL Server Management Studio
Reply With Quote
  #30  
Old 03-08-2018, 04:53 PM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,428
Default

Quote:
Originally Posted by redearedslider View Post
This workflow intrigues me.
I don't think the order implies anything about chronology.
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 02:15 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.22203 seconds with 9 queries