Blog

Full Outer Join According to Wikipedia{:target="_blank"} - “Conceptually, a full outer join combines the effect of applying both left and right outer joins. Where rows in the FULL OUTER JOINed tables do not match, the result set will …

Try and Except Handle Exceptions Exceptions Attributes Handling Multiple Exceptions Else Finally Try and Except Handle Exceptions The following statement will throw an error as string can’t be parsed into integers. hello = "hello …

Return in Function Scoping in Function Access global variable in function context Declare a local variable within in a function Declare local variable with same name as in global Using Global Keyword *args and **kwargs in function Return in Function …

Continue vs Break Continue print("The loop will skip the value when value of i is 2 and restart from next value of i - ") for i in range(0,4): if i == 2: continue else: print(i+100) Output: The loop will skip the value when value of i is 2 …

The following code snippets are on creating a connection to Azure Data Lake Storage Gen1 using R with Service-to-Service authentication with client secret and client id using REST API. Follow the link, for more details on different ways to connect …

Importing Packages and Datasets import pandas as pd import numpy as np start_date = ['2019-06-03', '2019-06-13', '2018-11-05', '2019-05-31', '2019-06-01', '2019-09-01'] end_date = …

Importing Packages and Datasets import pandas as pd start_date = ['2019-06-03', '2019-06-13', '2019-10-01', '2019-09-01'] end_date = ['2019-08-31', '2019-06-21', '2019-10-25', …

Importing Packages and Datasets import pandas as pd import numpy as np data = pd.DataFrame(np.random.rand(4, 3)*100, columns=['Physics','Çhemistry','Maths'], index = ['Student 1', 'Student 2','Student …

Filtering a dataframe can be achieved in multiple ways using pandas. There are times when you simply need to update a column based on a condition which is true or vice-versa. In pandas dataframe there are some inbuilt methods to achieve the same …

String operations in python, sometimes can be a bit tedious, specially when we need to pass variables within Strings. Although there are multiple ways to achieve the same, but some of the them are String interpolation str.format() Declaring some …