Happy May Day!
DataPandas wishes you Happy International Workers’ Day!


The sp_execute_external_script system stored procedure is the stored procedure which invokes the external environment to run an external script (either Python or R ) in a T-SQL script. This is quite highlights of the sp_execute_external_script stored and some short notes on it. let’s quickly look at the structure of the stored procedure sp_execute_external_script @language = N’language,…
In this quick notes, we will have a look at Rank and Sort in Series and DataFrames in Python In [1]:
|
1 2 3 |
import numpy as np import pandas as pd from pandas import Series, DataFrame |
In [3]:
|
1 2 3 |
#make a series ser1 = Series(range(3), index=['C','A','B']) ser1 |
Out[3]:
|
1 2 3 4 |
C 0 A 1 B 2 dtype: int32 |
In [4]:
|
1 2 |
#sort index of series ser1.sort_index() |
Out[4]:
|
1 2 3 4 |
A 1 B 2 C 0 dtype: int32 |
In [5]:
|
1 2 |
#order or sort by values ser1.order() |
|
1 2 |
C:\Users\adaba\Anaconda3\lib\site-packages\ipykernel\__main__.py:2: FutureWarning: order is deprecated, use sort_values(...) from ipykernel import kernelapp as app |
Out[5]:
|
1 2 3 4 |
C 0 A 1 B 2 dtype: int32 |
In [6]:
|
1 |
ser1.sort_values() |
Out[6]:
|
1 2 3 4 |
C 0 A 1 B 2 dtype: int32 |
In [7]:
|
1 |
from numpy.random import randn |
In [8]:
|
1 2 3 |
#make a series by passing in 10 random numbers ser2 = Series(randn(10)) ser2 |
Out[8]:
|
1 2 3 4 5 6 7 8 9 10 11 |
0 -0.201751 1 1.534109 2 0.542825 3 1.421174 4 -0.173771 5 0.002573 6 -0.490208 7 -0.765340 8 -2.546040 9 -0.456699 dtype: float64 |
In [10]:
|
1 2 |
#sort the values ser2.sort_values() |
…
This is a guide on Python List comprehension. List comprehension is a great way to write simple and easy to read Python codes. You can use it dictionaries and sets as well. Credits to Corey Schafer , creator of Python course materials. lets create a list In [115]:
|
1 2 |
num = range(10) num |
Out[115]:
|
1 |
[0, 1, 2, 3, 4, 5, 6, 7, 8, 9] |
lets grab all the…
Want more information like this?
What is population size: In simple terms, let’s us say population is the WHOLE SET and What is sample size: let us say it is the SUBSET (which is within the whole set) The norm Normally subsets are within the whole set and are smaller than the whole set Can they be equal ? Yes…
Want more information like this?
An experienced DevOps and Cloud Training Company to meet your DevOps and Cloud needs
You can see how this popup was set up in our step-by-step guide: https://wppopupmaker.com/guides/auto-opening-announcement-popups/