Pastebin
API
tools
faq
paste
Login
Sign up
Elena1234's Pastebin
20,500
392,691
3
4 years ago
Name / Title
Added
Expires
Hits
Comments
Syntax
Date format
Apr 12th, 2022
Never
898
0
R
-
sapply() with function with two arguments
Apr 12th, 2022
Never
1,529
0
R
-
Anonymous function with sapply()
Apr 12th, 2022
Never
1,501
0
R
-
Function any()
Apr 11th, 2022
Never
421
0
R
-
Iterate through matrix
Apr 11th, 2022
Never
1,871
0
R
-
Sort function
Apr 11th, 2022
Never
424
0
R
-
How to export to Excel
Apr 8th, 2022
Never
430
0
R
-
How to create a new column
Apr 6th, 2022
Never
425
0
R
-
Create dataframe and rename rows
Apr 6th, 2022
Never
2,140
0
R
-
Read and Write into a CSV file
Apr 6th, 2022
Never
2,280
0
R
-
Select data with subset or with $
Apr 6th, 2022
Never
849
0
R
-
Order in Asc and Dsc
Apr 6th, 2022
Never
1,815
0
R
-
Dynamic SQL ( How to concatenate varchar and variable)
Mar 28th, 2022
Never
411
0
T-SQL
-
IF Statements with UNION ALL ( T-SQL )
Mar 28th, 2022
Never
1,414
0
T-SQL
-
IF Statements ( T-SQL )
Mar 28th, 2022
Never
1,275
0
T-SQL
-
Stored Procedures ( T-SQL )
Mar 27th, 2022
Never
445
0
T-SQL
-
User Defined Functions ( T-SQL)
Mar 27th, 2022
Never
1,797
0
T-SQL
-
Create Function with % ( T-SQL)
Mar 27th, 2022
Never
1,583
0
T-SQL
-
Create Function with Parameters ( T-SQL )
Mar 27th, 2022
Never
1,710
0
T-SQL
-
Code to create user defined function ( T-SQL )
Mar 27th, 2022
Never
561
0
T-SQL
-
How to Calculate Pay Period ( T- SQL )
Mar 27th, 2022
Never
1,794
0
T-SQL
-
Variables for complex Date math ( T-SQL )
Mar 27th, 2022
Never
1,329
0
T-SQL
-
Calendar Table ( T-SQL )
Mar 15th, 2022
Never
490
0
T-SQL
-
Populate Calendar Table (T-SQL)
Mar 15th, 2022
Never
1,663
0
T-SQL
-
How to create Calendar Table ( T-SQL)
Mar 15th, 2022
Never
2,459
0
T-SQL
-
Optimizing With UPDATE ( T-SQL )
Mar 14th, 2022
Never
2,067
0
T-SQL
-
RECURSION IN T-SQL
Mar 9th, 2022
Never
2,403
0
T-SQL
-
PIVOT ( T-SQL) - broken out by Gender
Mar 8th, 2022
Never
2,025
0
T-SQL
-
PIVOT ( T-SQL)
Mar 8th, 2022
Never
1,699
0
T-SQL
-
FOR XML PATH With STUFF ( T-SQL )
Mar 8th, 2022
Never
439
0
T-SQL
-
ROW_NUMBER and CASE statement ( T-SQL)
Mar 2nd, 2022
Never
2,391
0
T-SQL
-
One to many from one table ( T-SQL )
Jan 31st, 2022
Never
3,956
0
T-SQL
-
Delete Database ( T-SQL )
Jan 30th, 2022
Never
3,597
0
T-SQL
-
Function with Common Table Expression ( T-SQL )
Jan 11th, 2022
Never
518
0
T-SQL
-
DROP DATABASE ( T-SQL )
Jan 10th, 2022
Never
4,381
0
T-SQL
-
Disable or Re-create all constraints ( T-SQL )
Jan 10th, 2022
Never
3,952
0
T-SQL
-
Salary Level Function ( T-SQL )
Jan 10th, 2022
Never
4,319
0
T-SQL
-
Salary higher than the average salary (T-SQL)
Jan 5th, 2022
Never
526
0
T-SQL
-
Third Highest Salary ( T-SQL )
Jan 5th, 2022
Never
764
0
T-SQL
-
Highest Peak and Longest River by Country - with CTE ( T-SQL )
Dec 31st, 2021
Never
565
0
T-SQL
-
Continents and Currencies - with CTE ( T-SQL )
Dec 31st, 2021
Never
1,263
0
T-SQL
-
Join one table with itself ( T-SQL )
Dec 30th, 2021
Never
5,428
0
T-SQL
-
DATEADD() in T-SQL
Dec 28th, 2021
Never
4,979
0
T-SQL
-
Select everything after character ( T-SQL )
Dec 27th, 2021
Never
4,796
0
T-SQL
-
How to use double Select in T-SQL
Dec 27th, 2021
Never
4,992
0
T-SQL
-
Switch Case in T-SQL
Dec 21st, 2021
Never
1,507
0
T-SQL
-
na values and non-null values in Python
Oct 8th, 2024
Never
116
0
Python
-
Yahoo Finance - code in Python
Jun 29th, 2024
Never
691
0
Python
-
replace all NaN with zeros in Python
Feb 10th, 2024
Never
1,274
0
Python
-
how to find and remove files
Dec 12th, 2023
Never
968
0
Bash
-
file creation using Expansion
Dec 11th, 2023
Never
723
0
Bash
-
highest of the top 10% values in Python
Oct 20th, 2023
Never
750
0
Python
-
Delete rows with low frequency values in Python
Oct 20th, 2023
Never
792
0
Python
-
conditions to fill in a column in dataframe in Python
Sep 22nd, 2023
Never
1,039
0
Python
-
how to iterate through dataframe and fill a column in Python
Sep 20th, 2023
Never
848
0
Python
-
how to find differences betwen two series in Python
Sep 20th, 2023
Never
607
0
Python
-
correlation heatmap in Python
Sep 12th, 2023
Never
765
0
Python
-
Plotting histograms from grouped data in Python
Sep 12th, 2023
Never
1,256
0
Python
-
logistic regression in Python
Sep 1st, 2023
Never
641
0
Python
-
3D matplotlib scatter plot
Aug 7th, 2023
Never
728
0
Python
-
strip all strings of a dataframe in Python
Jul 25th, 2023
Never
817
0
Python
-
Check about Multicollinearity in Python
Jul 19th, 2023
Never
909
0
Python
-
convert data types in DataFrame in Python
May 7th, 2023
Never
1,056
0
Python
-
Time Series and grouping by year and month in Python
May 5th, 2023
Never
793
0
Python
-
how to replace scientific notation in Python
May 5th, 2023
Never
1,085
0
Python
-
many plots together from different df in Python
May 3rd, 2023
Never
907
0
Python
-
get the unique indexes after merge in Python
May 2nd, 2023
Never
1,188
0
Python
-
SEABORN plots - confidence interval, regression and correlation in Python
Mar 25th, 2023
Never
848
0
Python
-
scaling, standardization and Z score in Python
Mar 22nd, 2023
Never
672
0
Python
-
cut method and creating bins in Python
Mar 22nd, 2023
Never
823
0
Python
-
column transformation, mapping and dummy variables in Python
Mar 22nd, 2023
Never
692
0
Python
-
arithmetic operations in dataframe in Python
Mar 22nd, 2023
Never
631
0
Python
-
melt and pivot dataframe in Python
Mar 16th, 2023
Never
765
0
Python
-
crosstab, pivot_table and groupby in Python
Mar 16th, 2023
Never
751
0
Python
-
columns visualization with MATPLOTLIB in Python
Mar 9th, 2023
Never
1,086
0
Python
-
range , apply and lambda in Python
Mar 5th, 2023
Never
858
0
Python
-
summary statistics and accumulations in Python
Mar 5th, 2023
Never
861
0
Python
-
ranking dataframe with rank in Python
Mar 5th, 2023
Never
979
0
Python
-
changing values in dataframe in Python
Mar 4th, 2023
Never
714
0
Python
-
add new rows in dataframe in Pythom
Mar 4th, 2023
Never
960
0
Python
-
inspect the index and multiple indexes in Python
Mar 3rd, 2023
Never
1,040
0
Python
-
slice dataframe by top 20 percent in Python
Mar 3rd, 2023
Never
1,035
0
Python
-
create a column based on other column, apply , lambda in Python
Mar 2nd, 2023
Never
936
0
Python
-
openpyxl and print a column in Python
Mar 1st, 2023
Never
760
0
Python
-
comprehensions in Python
Mar 1st, 2023
Never
756
0
Python
-
Lambda , map and percentage discount in Python
Mar 1st, 2023
Never
896
0
Python
-
count separed with comma values in a column in MySQL
Feb 21st, 2023
Never
1,106
0
MySQL
-
UNION in MySQL
Feb 21st, 2023
Never
1,067
0
MySQL
-
common table expression and GROUP_CONCAT in MySQL
Feb 21st, 2023
Never
1,220
0
MySQL
-
pivoting with count and case in MySQL
Feb 20th, 2023
Never
1,154
0
MySQL
-
case statement in MySQL
Feb 20th, 2023
Never
917
0
MySQL
-
set Workbench
Feb 20th, 2023
Never
799
0
MySQL
-
reset the root password in MySQL
Feb 16th, 2023
Never
635
0
None
-
stored procedure blank in MySQL
Feb 16th, 2023
Never
1,295
0
MySQL
-
trigger blank in MySQL
Feb 13th, 2023
Never
1,267
0
MySQL
-
convert data from rows into columns in MySQL
Feb 12th, 2023
Never
1,745
0
MySQL
-
dense_rank and where with subquery in MySQL
Feb 12th, 2023
Never
1,378
0
MySQL
-
left merge with Pandas
Feb 11th, 2023
Never
902
0
Python
-
describe and display data set with Pandas
Feb 10th, 2023
Never
1,135
0
Python
-
add constraint on a existing table ( MySQL )
Feb 8th, 2023
Never
1,138
0
MySQL
-
1
2
3
4
5
6
Oldest
Public Pastes
Netflix Premium UHD Hits
JavaScript | 5 sec ago | 0.08 KB
Make $2000 in 15 minutes E
JavaScript | 11 sec ago | 0.07 KB
✅ Crypto Accounts
JavaScript | 20 sec ago | 0.08 KB
Make $2200 in 15 minutes T
JavaScript | 40 sec ago | 0.07 KB
FREE BTC GUIDE
JavaScript | 40 sec ago | 0.08 KB
MAKE $1000 INSTANTLY R
JavaScript | 51 sec ago | 0.07 KB
MAKE $500 INSTANTLY
JavaScript | 55 sec ago | 0.08 KB
✅ PayPal Hits
JavaScript | 1 min ago | 0.08 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!