API tools faq
paste
elena1234

Elena1234's Pastebin

24,108 450,096 3 6 years ago
Name / Title Added Expires Hits Comments Syntax  
Date format Apr 12th, 2022 Never 1,080 0 R -
sapply() with function with two arguments Apr 12th, 2022 Never 1,670 0 R -
Anonymous function with sapply() Apr 12th, 2022 Never 1,633 0 R -
Function any() Apr 11th, 2022 Never 507 0 R -
Iterate through matrix Apr 11th, 2022 Never 2,032 0 R -
Sort function Apr 11th, 2022 Never 519 0 R -
How to export to Excel Apr 8th, 2022 Never 541 0 R -
How to create a new column Apr 6th, 2022 Never 521 0 R -
Create dataframe and rename rows Apr 6th, 2022 Never 2,292 0 R -
Read and Write into a CSV file Apr 6th, 2022 Never 3,126 0 R -
Select data with subset or with $ Apr 6th, 2022 Never 945 0 R -
Order in Asc and Dsc Apr 6th, 2022 Never 1,943 0 R -
Dynamic SQL ( How to concatenate varchar and variable) Mar 28th, 2022 Never 507 0 T-SQL -
IF Statements with UNION ALL ( T-SQL ) Mar 28th, 2022 Never 1,557 0 T-SQL -
IF Statements ( T-SQL ) Mar 28th, 2022 Never 1,410 0 T-SQL -
Stored Procedures ( T-SQL ) Mar 27th, 2022 Never 544 0 T-SQL -
User Defined Functions ( T-SQL) Mar 27th, 2022 Never 1,928 0 T-SQL -
Create Function with % ( T-SQL) Mar 27th, 2022 Never 1,706 0 T-SQL -
Create Function with Parameters ( T-SQL ) Mar 27th, 2022 Never 1,835 0 T-SQL -
Code to create user defined function ( T-SQL ) Mar 27th, 2022 Never 657 0 T-SQL -
How to Calculate Pay Period ( T- SQL ) Mar 27th, 2022 Never 2,001 0 T-SQL -
Variables for complex Date math ( T-SQL ) Mar 27th, 2022 Never 1,480 0 T-SQL -
Calendar Table ( T-SQL ) Mar 15th, 2022 Never 589 0 T-SQL -
Populate Calendar Table (T-SQL) Mar 15th, 2022 Never 1,775 0 T-SQL -
How to create Calendar Table ( T-SQL) Mar 15th, 2022 Never 2,590 0 T-SQL -
Optimizing With UPDATE ( T-SQL ) Mar 14th, 2022 Never 2,185 0 T-SQL -
RECURSION IN T-SQL Mar 9th, 2022 Never 2,555 0 T-SQL -
PIVOT ( T-SQL) - broken out by Gender Mar 8th, 2022 Never 2,145 0 T-SQL -
PIVOT ( T-SQL) Mar 8th, 2022 Never 1,804 0 T-SQL -
FOR XML PATH With STUFF ( T-SQL ) Mar 8th, 2022 Never 554 0 T-SQL -
ROW_NUMBER and CASE statement ( T-SQL) Mar 2nd, 2022 Never 2,524 0 T-SQL -
One to many from one table ( T-SQL ) Jan 31st, 2022 Never 4,052 0 T-SQL -
Delete Database ( T-SQL ) Jan 30th, 2022 Never 3,727 0 T-SQL -
Function with Common Table Expression ( T-SQL ) Jan 11th, 2022 Never 634 0 T-SQL -
DROP DATABASE ( T-SQL ) Jan 10th, 2022 Never 4,495 0 T-SQL -
Disable or Re-create all constraints ( T-SQL ) Jan 10th, 2022 Never 4,078 0 T-SQL -
Salary Level Function ( T-SQL ) Jan 10th, 2022 Never 4,477 0 T-SQL -
Salary higher than the average salary (T-SQL) Jan 5th, 2022 Never 630 0 T-SQL -
Third Highest Salary ( T-SQL ) Jan 5th, 2022 Never 903 0 T-SQL -
Highest Peak and Longest River by Country - with CTE ( T-SQL ) Dec 31st, 2021 Never 661 0 T-SQL -
Continents and Currencies - with CTE ( T-SQL ) Dec 31st, 2021 Never 1,416 0 T-SQL -
Join one table with itself ( T-SQL ) Dec 30th, 2021 Never 5,559 0 T-SQL -
DATEADD() in T-SQL Dec 28th, 2021 Never 5,103 0 T-SQL -
Select everything after character ( T-SQL ) Dec 27th, 2021 Never 4,917 0 T-SQL -
How to use double Select in T-SQL Dec 27th, 2021 Never 5,127 0 T-SQL -
Switch Case in T-SQL Dec 21st, 2021 Never 1,626 0 T-SQL -
na values and non-null values in Python Oct 8th, 2024 Never 227 0 Python -
Yahoo Finance - code in Python Jun 29th, 2024 Never 854 0 Python -
replace all NaN with zeros in Python Feb 10th, 2024 Never 1,404 0 Python -
how to find and remove files Dec 12th, 2023 Never 1,109 0 Bash -
file creation using Expansion Dec 11th, 2023 Never 873 0 Bash -
highest of the top 10% values in Python Oct 20th, 2023 Never 870 0 Python -
Delete rows with low frequency values in Python Oct 20th, 2023 Never 938 0 Python -
conditions to fill in a column in dataframe in Python Sep 22nd, 2023 Never 1,182 0 Python -
how to iterate through dataframe and fill a column in Python Sep 20th, 2023 Never 955 0 Python -
how to find differences betwen two series in Python Sep 20th, 2023 Never 736 0 Python -
correlation heatmap in Python Sep 12th, 2023 Never 875 0 Python -
Plotting histograms from grouped data in Python Sep 12th, 2023 Never 1,383 0 Python -
logistic regression in Python Sep 1st, 2023 Never 766 0 Python -
3D matplotlib scatter plot Aug 7th, 2023 Never 853 0 Python -
strip all strings of a dataframe in Python Jul 25th, 2023 Never 930 0 Python -
Check about Multicollinearity in Python Jul 19th, 2023 Never 1,043 0 Python -
convert data types in DataFrame in Python May 7th, 2023 Never 1,194 0 Python -
Time Series and grouping by year and month in Python May 5th, 2023 Never 953 0 Python -
how to replace scientific notation in Python May 5th, 2023 Never 1,221 0 Python -
many plots together from different df in Python May 3rd, 2023 Never 1,024 0 Python -
get the unique indexes after merge in Python May 2nd, 2023 Never 1,307 0 Python -
SEABORN plots - confidence interval, regression and correlation in Python Mar 25th, 2023 Never 981 0 Python -
scaling, standardization and Z score in Python Mar 22nd, 2023 Never 828 0 Python -
cut method and creating bins in Python Mar 22nd, 2023 Never 997 0 Python -
column transformation, mapping and dummy variables in Python Mar 22nd, 2023 Never 819 0 Python -
arithmetic operations in dataframe in Python Mar 22nd, 2023 Never 789 0 Python -
melt and pivot dataframe in Python Mar 16th, 2023 Never 922 0 Python -
crosstab, pivot_table and groupby in Python Mar 16th, 2023 Never 869 0 Python -
columns visualization with MATPLOTLIB in Python Mar 9th, 2023 Never 1,209 0 Python -
range , apply and lambda in Python Mar 5th, 2023 Never 1,001 0 Python -
summary statistics and accumulations in Python Mar 5th, 2023 Never 997 0 Python -
ranking dataframe with rank in Python Mar 5th, 2023 Never 1,111 0 Python -
changing values in dataframe in Python Mar 4th, 2023 Never 826 0 Python -
add new rows in dataframe in Pythom Mar 4th, 2023 Never 1,092 0 Python -
inspect the index and multiple indexes in Python Mar 3rd, 2023 Never 1,171 0 Python -
slice dataframe by top 20 percent in Python Mar 3rd, 2023 Never 1,173 0 Python -
create a column based on other column, apply , lambda in Python Mar 2nd, 2023 Never 1,069 0 Python -
openpyxl and print a column in Python Mar 1st, 2023 Never 918 0 Python -
comprehensions in Python Mar 1st, 2023 Never 872 0 Python -
Lambda , map and percentage discount in Python Mar 1st, 2023 Never 1,020 0 Python -
count separed with comma values in a column in MySQL Feb 21st, 2023 Never 1,273 0 MySQL -
UNION in MySQL Feb 21st, 2023 Never 1,186 0 MySQL -
common table expression and GROUP_CONCAT in MySQL Feb 21st, 2023 Never 1,357 0 MySQL -
pivoting with count and case in MySQL Feb 20th, 2023 Never 1,292 0 MySQL -
case statement in MySQL Feb 20th, 2023 Never 1,058 0 MySQL -
set Workbench Feb 20th, 2023 Never 937 0 MySQL -
reset the root password in MySQL Feb 16th, 2023 Never 816 0 None -
stored procedure blank in MySQL Feb 16th, 2023 Never 1,400 0 MySQL -
trigger blank in MySQL Feb 13th, 2023 Never 1,380 0 MySQL -
convert data from rows into columns in MySQL Feb 12th, 2023 Never 1,862 0 MySQL -
dense_rank and where with subquery in MySQL Feb 12th, 2023 Never 1,488 0 MySQL -
left merge with Pandas Feb 11th, 2023 Never 1,016 0 Python -
describe and display data set with Pandas Feb 10th, 2023 Never 1,276 0 Python -
add constraint on a existing table ( MySQL ) Feb 8th, 2023 Never 1,255 0 MySQL -
Public Pastes
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!