Variables in DataFrame
Each column in table refers to variable in python. It can be categorized into two categories.
This blog is about working with data by using different tools Excel ,Python, Access Power automate etc .
Each column in table refers to variable in python. It can be categorized into two categories.
Below are list of arithmetic operators used in python for mathematical operations.
Below are list of operator that are used for comparison in python.
It return True if string starts with specified prefix otherwise False. To determine whether string starts with specified prefix we…
To check length of the word or to check how many letters or character in cell we can use len…
Sometimes data contains duplicate entries in a column. We can check it by selecting column click on Home->conditional formatting->highlight cell…
Merging of excel file is common task one can merge excel files manually by copying one files content to other.…
Str.split & rsplit function both split the string by separator given in str.split does it from beginning and str.rsplit starting…
use power automate to automate routine task whenever a new file is created in one drive folder. We will use…