elena1234

Elena1234's Pastebin

11,737 252,135 0 2 years ago
Name / Title Added Expires Hits Comments Syntax  
Date format Apr 12th, 2022 Never 413 0 R -
sapply() with function with two arguments Apr 12th, 2022 Never 958 0 R -
Anonymous function with sapply() Apr 12th, 2022 Never 916 0 R -
Function any() Apr 11th, 2022 Never 142 0 R -
Iterate through matrix Apr 11th, 2022 Never 1,223 0 R -
Sort function Apr 11th, 2022 Never 153 0 R -
How to export to Excel Apr 8th, 2022 Never 161 0 R -
How to create a new column Apr 6th, 2022 Never 148 0 R -
Create dataframe and rename rows Apr 6th, 2022 Never 1,493 0 R -
Read and Write into a CSV file Apr 6th, 2022 Never 1,561 0 R -
Select data with subset or with $ Apr 6th, 2022 Never 543 0 R -
Order in Asc and Dsc Apr 6th, 2022 Never 1,265 0 R -
Dynamic SQL ( How to concatenate varchar and variable) Mar 28th, 2022 Never 132 0 T-SQL -
IF Statements with UNION ALL ( T-SQL ) Mar 28th, 2022 Never 972 0 T-SQL -
IF Statements ( T-SQL ) Mar 28th, 2022 Never 921 0 T-SQL -
Stored Procedures ( T-SQL ) Mar 27th, 2022 Never 166 0 T-SQL -
User Defined Functions ( T-SQL) Mar 27th, 2022 Never 1,424 0 T-SQL -
Create Function with % ( T-SQL) Mar 27th, 2022 Never 1,274 0 T-SQL -
Create Function with Parameters ( T-SQL ) Mar 27th, 2022 Never 1,406 0 T-SQL -
Code to create user defined function ( T-SQL ) Mar 27th, 2022 Never 225 0 T-SQL -
How to Calculate Pay Period ( T- SQL ) Mar 27th, 2022 Never 1,476 0 T-SQL -
Variables for complex Date math ( T-SQL ) Mar 27th, 2022 Never 972 0 T-SQL -
Calendar Table ( T-SQL ) Mar 15th, 2022 Never 195 0 T-SQL -
Populate Calendar Table (T-SQL) Mar 15th, 2022 Never 1,377 0 T-SQL -
How to create Calendar Table ( T-SQL) Mar 15th, 2022 Never 2,119 0 T-SQL -
Optimizing With UPDATE ( T-SQL ) Mar 14th, 2022 Never 1,719 0 T-SQL -
RECURSION IN T-SQL Mar 9th, 2022 Never 2,086 0 T-SQL -
PIVOT ( T-SQL) - broken out by Gender Mar 8th, 2022 Never 1,723 0 T-SQL -
PIVOT ( T-SQL) Mar 8th, 2022 Never 1,389 0 T-SQL -
FOR XML PATH With STUFF ( T-SQL ) Mar 8th, 2022 Never 166 0 T-SQL -
ROW_NUMBER and CASE statement ( T-SQL) Mar 2nd, 2022 Never 2,073 0 T-SQL -
One to many from one table ( T-SQL ) Jan 31st, 2022 Never 3,608 0 T-SQL -
Delete Database ( T-SQL ) Jan 30th, 2022 Never 3,295 0 T-SQL -
Function with Comman Table Expression ( T-SQL ) Jan 11th, 2022 Never 213 0 T-SQL -
DROP DATABASE ( T-SQL ) Jan 10th, 2022 Never 4,072 0 T-SQL -
Disable or Re-create all constraints ( T-SQL ) Jan 10th, 2022 Never 3,650 0 T-SQL -
Salary Level Function ( T-SQL ) Jan 10th, 2022 Never 3,989 0 T-SQL -
Salary higher than the average salary (T-SQL) Jan 5th, 2022 Never 219 0 T-SQL -
Third Highest Salary ( T-SQL ) Jan 5th, 2022 Never 403 0 T-SQL -
Highest Peak and Longest River by Country - with CTE ( T-SQL ) Dec 31st, 2021 Never 286 0 T-SQL -
Continents and Currencies - with CTE ( T-SQL ) Dec 31st, 2021 Never 817 0 T-SQL -
Join one table with itself ( T-SQL ) Dec 30th, 2021 Never 5,090 0 T-SQL -
DATEADD() in T-SQL Dec 28th, 2021 Never 4,682 0 T-SQL -
Select everything after character ( T-SQL ) Dec 27th, 2021 Never 4,499 0 T-SQL -
How to use double Select in T-SQL Dec 27th, 2021 Never 4,611 0 T-SQL -
Switch Case in T-SQL Dec 21st, 2021 Never 1,223 0 T-SQL -
how to slice string column in data frame in Python Dec 1st, 2022 Never 905 0 Python -
read xlsb file in Python Nov 30th, 2022 Never 8 0 None -
create multiple excel sheets Nov 23rd, 2022 Never 652 0 Python -
replace all blank space with np.nan in Python Nov 23rd, 2022 Never 746 1 Python -
convert list column into string ( DataFrame ) Nov 17th, 2022 Never 636 0 Python -
convert string into hyperlink in Python Nov 16th, 2022 Never 13 0 Python -
convert string column into numeric in Python Nov 16th, 2022 Never 20 0 Python -
how to rename column in Python Nov 16th, 2022 Never 869 0 Python -
how to scrap a table in Python Nov 9th, 2022 Never 650 0 Python -
how to replace many chars in Python Nov 7th, 2022 Never 901 0 Python -
remove string from column in Python Nov 3rd, 2022 Never 468 0 Python -
scrape Label for elements with Selenium Oct 27th, 2022 Never 32 0 Python -
get most frequent locations in Python Oct 24th, 2022 Never 684 0 Python -
custom histogram in Python Oct 24th, 2022 Never 556 0 Python -
date format in Python Oct 14th, 2022 Never 693 0 Python -
RegEx for cyrillic in Python Oct 13th, 2022 Never 553 0 Python -
how to swap and replace columns in Python Oct 13th, 2022 Never 531 0 Python -
loop over rows in DataFrame in Python Oct 13th, 2022 Never 664 0 Python -
extract salary in Python Oct 13th, 2022 Never 28 0 None -
regex in Python Oct 13th, 2022 Never 29 0 None -
move column to specific place in Python Oct 12th, 2022 Never 363 0 Python -
scrolling infinite pages with Selenium Oct 5th, 2022 Never 844 0 Python -
convert column in df into DateTime format in Python Sep 26th, 2022 Never 990 0 Python -
how to delete partial string in df in Python Sep 26th, 2022 Never 590 0 Python -
Kurtosis in Python Jul 25th, 2022 Never 1,068 0 Python -
Skewed - data analysis and transformations Jul 25th, 2022 Never 1,006 0 Python -
Friedman test for paired data and Post-Hoc tests Jul 22nd, 2022 Never 894 0 Python -
Post-Hoc test in Python Jul 22nd, 2022 Never 381 0 Python -
Data Transformation in Python Jul 21st, 2022 Never 248 0 Python -
One-Way ANOVA in Python Jul 20th, 2022 Never 861 0 Python -
table transformation before ANOVA Jul 20th, 2022 Never 611 0 Python -
Uniform Distribution in Python Jul 5th, 2022 Never 1,048 0 Python -
Normal Distribution in Python Jul 4th, 2022 Never 905 0 Python -
Poisson Distribution in Python Jul 4th, 2022 Never 781 0 Python -
Binomial Distribution in Python ( cdf and pmf ) Jul 1st, 2022 Never 735 0 Python -
Q-Q plot (check for normality) Jun 22nd, 2022 Never 671 0 Python -
see all columns in DataFrame Jun 19th, 2022 Never 967 0 Python -
cut, population mean and sample size in Python Jun 7th, 2022 Never 186 0 Python -
population proportion , agg and total n in Python Jun 6th, 2022 Never 766 0 Python -
cross table in Python Jun 6th, 2022 Never 70 0 Python -
float column into int column in Python May 30th, 2022 Never 622 0 Python -
lineplot with groupby in Python May 29th, 2022 Never 78 0 None -
nlargest in Python May 28th, 2022 Never 734 0 Python -
how to creat count plot in Python May 25th, 2022 Never 879 0 Python -
kdeplot in Python May 25th, 2022 Never 511 0 Python -
Pivot table and Aggregate function in Python May 22nd, 2022 Never 306 0 Python -
update column values with apply in Python May 21st, 2022 Never 959 0 Python -
concatenate two columns into one new column May 21st, 2022 Never 876 0 Python -
how to delete column in Python May 21st, 2022 Never 861 0 Python -
from Excel sheets into Dataframe in Python May 21st, 2022 Never 597 0 Python -
max function with lambda in Python May 20th, 2022 Never 943 0 Python -
emperical rule in Python May 19th, 2022 Never 730 0 Python -
random sampling- calculate avg mean and avg std in Python May 19th, 2022 Never 321 0 Python -
Sampling from a entire and biased population in Python May 19th, 2022 Never 363 0 Python -