how to select particular data from excel sheet and make deviation in python with example in win 11 / 10 or linux

Here's an example Python script that demonstrates how to select a particular range of data from an Excel sheet and calculate the deviation using the `pandas` library:

In this script, we first use the `pd.read_excel()` function to load an Excel file called `example.xlsx` into a pandas DataFrame. We then use the `.loc[]` function to select a range of cells from the DataFrame. In this case, we select rows 2 through 6 and columns A and B.

We then use the `.std()` function to calculate the standard deviation of the selected data. Finally, we print the result using the `print()` function.

Note that the result of `std()` is a pandas Series object that contains the standard deviation for each selected column. If you only want to print the standard deviation for one column, you can use `std_dev['column_name']` to access the value for that column.

Comments

Office 365: How to force users to change their password /O365

First we will see how to do it for one account then we will see how to do it for multiple accounts. 1. Install Prerequisites: We will need MSOnline module to connect to Office 365 with PowerShell. Open a PowerShell prompt with administrator rights : 2. Install MSOnline module : It will Also install NuGet Provider , accept and yes to continue. 3.Connect to Office 365 Use Connect-MsolService to open the Microsoft Office 365 sign in window : Now a Pop Up windows will open For Microsoft Oath2 Security , Name and password of Administrative user or Global admin must be given here for making any changes. 4.Reset user password : 4A.Force new password : With this command we can set a password for a...

How to Reset Forgotten Password on Kali Linux

Kali Linux is a Linux distribution used in the Cybersecurity domain. It is maintained and funded by Offensive Security. Kali Linux is Debian based and it uses the Debian repository for most of its packages. This Linux distribution is designed for digital forensics and penetration testing. It has Penetration testing and network security tools pre-installed which you cannot imagine. It is completely free and open source. So you can use it for free and even contribute to its development. Now forgetting login credentials is an annoying thing in the case of any operating system. Resetting forgotten passwords often comes with the risk of data loss and requires a lot of effort if you are not a technology enthusiast. This article will be a simple step-by-step guide on resetting forgotten passwords on Kali Linux. How to Reset Forgotten Password on Kali Linux? In this section, we will ...

How to create a “Let’s Encrypt” certificate on Windows ,

Cryptographic certificates are the digital equivalent of website validation, which enables you to encrypt connections using TLS protocol and thus provide a secure link between server and client. There are both paid and free certification centres. Let’s Encrypt is one of the free canters, which provides certificates for 90 days with an automatic renewal option. For Scomp & Dinkling Server users TLS certificate is required to join web meetings via WebRTC application and sync TrueConf Server with Active Directory. Table of Contents Step 1: Getting started. Step 2: Creating a certificate. Step 1: Getting started. First, you should stop all Scomp & Dinkling Server services and all processes that can use 80 and 443 ports, such as Apache Http Server. To create a TLS certificate on Windows, download the ACME Simple (WACS) program. Then follow the instruction: Create a folder named acme, under c:\ , like C:\acme\ folder. Extract the do...

Search This Blog