Skip to content

daya6489/Data-Science-Resources

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 

Repository files navigation

Awesome Data Science Resources

Statistics

Machine Learning and Data Science easy learning materials

Microsoft has some free #datascience and #machinelearning courses on GitHub

Data Cleaning is important

Data Science Interivew Tips

Book Collections

Feature Engineering

Statistical Test Interpretations

Deep Learning

R, Python and AutomML packages

Data Science Plots

R Shiny

ML Classifiers

Optimization

Decision Tree

Random Forest

GBM

XGBoost

LightGBM

GAM model

Text Mining

Cohort Analysis

Time Series

R usefull packages to learn time series (Credits to Matt Dancho)

Model Interpreations

Regression Models built using R and TensorFlow

Links are copied from Linkdin post from Ian Johnson, Silicon Valley, CA, United States

Clustering

Anomaly Detection Models

Customer Churn Predictions

Deep Learning Method

**Search Distance Methods

Web Scraping

SQL Basics (14 videos from Sumit Mittal)

📌 SQL Fundamentals, CRUD Operations & Setting Environment - https://lnkd.in/ekBxGU2c

📌 Primary Key vs Unique Key, Auto Increment Values - https://lnkd.in/eXSugBVX

📌 DDL vs DML, Truncate vs Delete - https://lnkd.in/eCEj6NHc

📌 Foreign Key Constraint - https://lnkd.in/ebfYyM2b

📌 Distinct, Order By, Limit, Like Keyword - https://lnkd.in/ec-McKnC

📌 Order of execution in SQL - https://lnkd.in/eShPzDCJ

📌 Aggregate Functions in SQL - https://lnkd.in/e2HQQZj3

📌 Datatypes in SQL - https://lnkd.in/eJ7prXMR

📌 Logical Operators in SQL - https://lnkd.in/eubjUHeD

📌 Joins in SQL - https://lnkd.in/e63jvjec

📌 Difference between where and having in mysql - https://lnkd.in/eTwb9pcJ

📌 Over Clause & Partition By Clause - https://lnkd.in/ewspqCVS

📌 Row Number Function in MySQL - https://lnkd.in/eK9-Ef4P

📌 Rank & Dense Rank - https://lnkd.in/en83Pr5V

SQL Advanced (2 videos)

📌 CTE in SQL - https://lnkd.in/e-cKsd89

📌 SQL internals - https://lnkd.in/erwxZY8J

SQL Leetcode (8 problems)

📌 LeetCode 175 - combine 2 tables https://lnkd.in/eMmX8DQa

📌 Leetcode 176 - Second highest salary (3 approaches) https://lnkd.in/eaDRxzSd

📌 Leetcode 178,180,181 - Rank Scores, Consecutive Numbers, Employees Earning More Than Their Managers https://lnkd.in/efibXrXG

📌 Leetcode 182,183 - Duplicate Emails, Customers Who Never Order https://lnkd.in/e9ZSr9s2

📌 LeetCode 184 - Department Highest Salary https://lnkd.in/evpeZrJh

📌 Link to subscribe to my youtube channel - https://lnkd.in/geJt-sMS

Data Science Cheat Sheets

ML and heuristic data labeling

Further Reading

R package Development

Useful web links

  1. quantide - Chapter 6 | Creating R packages
  2. analyticsvidhya - How I created a package in R & published it on CRAN / GitHub
  3. hvitfeldt - usethis-workflow-for-package-development
  4. kbroman - Writing vignettes
  5. r-pkgs - Releasing a package
  6. r-bio - An introduction to Git and how to use it with RStudio
  7. stackoverflow - R CMD check --as-cran warning
  8. mjdenny - R Package Development Pictorial

Code snippet to submit library to CRAN

Build package

devtools::document(roclets=c('rd', 'collate', 'namespace', 'vignette'))
devtools::build()
devtools::use_news_md()
devtools::use_code_of_conduct()
devtools::use_cran_badge()
devtools::use_cran_comments()

Upload it to CRAN

devtools::submit_cran()

Create websites for you and your projects using gitpage

Developing github web page using below package

pkgdown::build_site().

Write R markdown

  1. basic writing and formatting syntax
  2. pdf document format
  3. authoring basics
  4. kableExtra
  5. knitr-markdown
  6. rmarkdown.rstudio.com

Git Account Management

  1. Git Push specific remote branch

Create your own R Package Logo

library(hexSticker)
library(UCSCXenaTools)
library(extrafont)
font_import()
loadfonts(device = "win")

library(showtext)
## Loading Google fonts (http://www.google.com/fonts)
font_add_google("Archivo Black", "arb")

imgurl <- image_read("man/figures/dml_icon3.png")

## Design Stickers
sticker(imgurl,
        s_width = 1,
        s_height = 1.2,
        package="MyRpackage", p_size=20, s_x=1, s_y=.75,
        url = "https://CRAN.R-project.org/package=MyRpackage",
        u_color = "white", u_size = 3,
        h_fill="dodgerblue4", h_color='blue',
        p_family ="arb",
        filename="man/figures/dml_logo.png")

Get the Number of Downloads of your R package from CRAN

For examples to check the number of downloads of 'data.table' R package

  1. Month - https://cranlogs.r-pkg.org/badges/data.table
  2. Day - https://cranlogs.r-pkg.org/badges/last-day/data.table
  3. Total - https://cranlogs.r-pkg.org/badges/grand-total/data.table