Datasnips was built out of frustration in wasting time searching for Data Science & AI code snippets through old projects, documentation and internet sources.

We wanted a platform to easily find & organise our snippets, to share them with the community and discover those shared by other users.

At Datasnips you can quickly search, discover and bookmark snippets from the community, curate your own snippet library for easy reference and share your own snippets for others to use.

Our aim is for Datasnips to be the place where everyone can find the code snippet they need. Sign up to be part of the community.

SQL Snippets

Getting the Last Record Using Rank Function - T-SQL Example

SQL

Querying

GregHe1979

2

Getting the Date for the Previous Saturday with T-SQL

SQL

Querying

GregHe1979

2

Remove Leading Zeros from a Field with T-SQL

SQL

Querying

#T-SQL #Data Cleaning

GregHe1979

2

median

SQL

Querying

changjulian17

2

left join LATERAL

SQL

Querying

changjulian17

2

Join on Multiple Columns in SQL Query

SQL

Querying

#Joins #Multiple

analyseup

1

EXISTS

SQL

Querying

changjulian17

1

SQL RANK

SQL

Querying

changjulian17

1

SQL window function

SQL

Querying

changjulian17

1

SQL window function II: percent growth

SQL

Querying

changjulian17

1

SQL creating a view

SQL

Querying

changjulian17

1

SQL generate_series, dayofweek(DOW), weekday, functions

SQL

Querying

changjulian17

1

Top Contributors

analyseup

82

detro

75

GregHe1979

36

Find Snippets by Language

Find Snippets by Use

Data Preprocessing

Statistics & Probability

Visualisation & EDA

Data Preparation for Models

Supervised Learning

Computer Vision