October R-Ladies Dallas Community Meeting
Details
Hi, R-Ladies!
I'm pleased to annouce that we will feature two speakers in our virtual October R-Ladies Dallas Community Meeting.
You may recall that we voted to create a series of projects around the Loan Default Prosper dataset suggested in the Udacity course in Lesson 10 for the Final Project. Details are provided in this document. The Loan Default Prosper dataset is the second-to-last row in the table.
https://docs.google.com/document/d/1qEcwltBMlRYZT-l699-71TzInWfk4W9q5rTCSvDVMpc/pub
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Featured Talk: Cleaning and Exploring the Loan Prosper Dataset
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
R-Ladies Dallas member Pavitra has volunteered to demonstrate an approach for cleaning the loan dataset and performing an exploratory data analysis. These tools/methods will be extremely valuable not only on our group project but also in our daily work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lightning Talk: Creating Excel Workbooks Programmatically within R
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
R-Ladies Dallas organizer Sydeaka will discuss how the openxlsx package could be used to programmatically create Excel workbooks directly within an R session. She will provide a live demo of code that can accomplish the following, all using R code:
- create a new Excel workbook from scratch, or add content to an existing Excel Workbook
- create multiple spreadsheets within a notebook
- customize fonts & colors
- highlight/color cells based on logical conditions
- apply conditional formatting
- dynamically insert figures
R openxlsx package details:
- Reference manual: https://cran.r-project.org/web/packages/openxlsx/openxlsx.pdf
- Vignettes:
- https://cran.r-project.org/web/packages/openxlsx/vignettes/Introduction.html
- https://cran.r-project.org/web/packages/openxlsx/vignettes/Formatting.html
*************************************************************************
You are encouraged to click the link below to keep up with the group project and to join the Slack community. Slack is a messaging platform where we will share open job opportunities, free or low-cost online training materials, and R-Ladies group projects that will help you practice your R programming skills and develop a portfolio that could be used to showcase your skills to hiring managers.
Webinar + Slack sign-up: https://docs.google.com/forms/d/e/1FAIpQLSdJhvSg-YrNYOrmju1yrXvYhFM7xMey1WpDq1NSGIp6x41VaA/viewform
*************************************************************************
We expect all attendees to abide & be governed by our community code of conduct. Please take a moment to review our R-Ladies Global code of conduct (particularly if this is your first time attending!): https://github.com/rladies/starter-kit/wiki/Code-of-Conduct.