Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To create dynamic columns or headers using CSV, we can use multiple methods but the one method that I find most suitable is the PSObject method.Let assume that your CSV column headers depend on the input provided by the user. Input can be a text file, user prompt for headers, array, etc. For this example, we will use the text file as input.We have the below columns (headers) to create in the CSV file.We will use the below command to create headers using PSObject and then export them into the CSV file.$object = New-Object psobject foreach($item in (gc C:\Temp\DynamicHeaders.txt)){ ... Read More
To delete the Azure blob using Azure CLI, we can use “az storage blob” command with the “delete” parameter. Before running this command, we first need to make sure that the azure account is connected (az login) and the proper subscription is set (az account set).To work with the azure storage account we need to authenticate to the storage. We can use storage key or the storage connections string. Here, we have shown how to retrieve the connections string.$storageaccount = 'az204storage05june' $connectionstring = az storage account show-connection-string - n $storageaccount -otsvThe below command will delete the azure storage blob named ... Read More
To get blobs inside the Azure storage container using PowerShell, we will use the Get-AzStorageBlob command. . Before running this command, we need to make sure that the Azure cloud account is connected (Connect-AzAccount) and the proper subscription is set in which the storage account resides (Set-AzContext).To work with the storage accounts we first need to set the Context for it and we will use the storage account key to set the context.$rg = "az204" $storageaccount = "az204storage05june" $key = (Get-AzStorageAccountKey -ResourceGroupName $rg - Name $storageaccount)[0].Value $context = New-AzStorageContext -StorageAccountName $storageaccount - StorageAccountKey $keyWe have now created the Azure storage ... Read More
When you run Invoke-WebRequest or Invoke-RestMethod command, sometimes you get the error “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.” because there could be a certificate issue or the required windows version doesn’t support the TLS or SSL version. You can use the below command to bypass this error.[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}Or you can use the below code to resolve this error.Exampleadd-type @" using System.Net; using System.Security.Cryptography.X509Certificates; public class TrustAllCertsPolicy : ICertificatePolicy { public bool CheckValidationResult( ServicePoint srvPoint, X509Certificate certificate, WebRequest request, ... Read More
ProblemWrite a program to implement linear regression algorithm.User has to enter total number of values.SolutionThe solution to compute the linear regression in C programming language is as follows −Linear regression finds the relationship between two variables by connecting a linear equation to the observed data. One variable is to be an explanatory variable, and the other is a dependent variable.The logic with regards to linear regression is explained below −for(i=0;i
ProblemWrite the user functions to Delete N – Characters from Position in a given string. Here, the string is given by the user at runtime.SolutionThe solution to delete n characters in a given string is as follows −AlgorithmRefer an algorithm to delete n characters in a given string.Step 1 − StartStep 2 − Read string at runtimeStep 3 − Read position from where we need to delete the charactersStep 4 − Read n, number of characters to delete from that positionStep 5 − Call the function deletestr(str, p, n) jump to step 7Step 6 − StopStep 7 − Called function deletestr(str, ... Read More
ProblemFind the greatest common divisor (GCD) for the given two numbers by using the non-recursive function.SolutionIt is explained below how to find the greatest common divisor (GCD) for the given two numbers by using the non-recursive function.AlgorithmRefer an algorithm given below to find the greatest common divisor (GCD) for the given two numbers by using the non-recursive function.Step 1 − StartStep 2 − Read the integers a and bStep 3 − Call the function G=GCD(a, b) step 6Step 4 − Print G valueStep 5 − StopStep 6 − Called function: GCD(a, b)a. Initialize the i=1, j, remainder b. Remainder=i-(i/j*j) c. ... Read More
ProblemFind the greatest common divisor (GCD) for the given two numbers by using the recursive function in C programming language.SolutionThe solution to find the greatest common divisor (GCD) for the given two numbers by using the recursive function is as follows −AlgorithmRefer an algorithm given below to find the greatest common divisor (GCD) for the given two numbers by using the recursive function.Step 1 − Define the recursive function.Step 2 − Read the two integers a and b.Step 3 − Call recursive function.a. if i>j b. then return the function with parameters i, j c. if i==0 d. then return ... Read More
ProblemThe program to calculate the sum of the following expressionSum=1-n^2/2!+n^4/4!-n^6/6!+n^8/8!-n^10/10!User has to enter the value of n at runtime to calculate the sum of the series by using the predefined function power present in math.h library function.SolutionIt is explained below how to calculate sum of series using predefined function.AlgorithmRefer an algorithm given below to calculate sum of series by using the predefined function.Step 1 − Read the num valueStep 2 − Initialize fact = 1, sum = 1 and n =5Step 3 − for i= 1 to n a. compute fact= fact*i b. if i %2 = 0 c. ... Read More
A function is a self-contained block that carries out a specific well-defined task.Types of functionsFunctions are broadly classified into two types which are as follows −Predefined functionsUser defined functionsCommunications among functionsFunctions communicate among themselves by using arguments and return value.Farm of ‘C’ function for return-datatype function name (argument list) is as follows −{ local variable declarations; executable statements(s); return (expression); }For Example, void mul (int x, int y).{ int p; p=x*y; printf(“product = %d”, p); }Prototype functionsThese functions can be done in two ways as explained below −Create a copy of the function declaration ... Read More