Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Many times python will receive data from various sources which can be in different formats like csv, JSON etc which can be converted to python list or dictionaries etc. But to apply the calculations or analysis using packages like pandas, we need to convert this data into a dataframes. In this article we will see how we can convert a given python list whose elements are a nested dictionary, into a pandas Datframe.We first take the list of nested dictionary and extract the rows of data from it. Then we create another for loop to append the rows into the ... Read More
To check if a computer is connected to any domain we can use multiple methods. In this article, we can use two methods. One using the System Information of the computer and the second using the DirectoryServices .Net Class.First method using System Information and filter out a string called “Domain” which shows us if the computer is in the domain or the workgroup.systeminfo | findstr "Domain"OutputIf the computer is in the workgroup, It will show the workgroup name. For example, In the second method, we will use the directory service .Net class method name GetComputerDomain(). If the server is not connected to the ... Read More
To remove the computer from the domain we need to use the Remove-Computer command.Remove-Computer -ComputerName Test1-win2k16 ` -UnjoinDomainCredential Labdomain\Administrator ` -WorkgroupName WG -Restart -Force -PassThruIn the above example, the Computer name Test1-Win2k16 is going to remove from the domain with the domain credentials and it will be joined to WorkGroup named WG. If the system doesn’t restart due to any reason, you need to reboot the system manually.Here the computer name is the String[]. So you can provide multiple computers to remove from the domain. For example, Remove-Computer -ComputerName Test1-win2k16, ... Read More
To join any workgroup computer in the domain using PowerShell, we can use the Add-Computer command but before that, there are a few Windows prerequisite that DNS must be configured properly and the domain controller should be reachable and others should suffice then only PowerShell can use the command to join computer into a domain.Add-Computer -ComputerName Test1-win2k16 ` -DomainCredential Labdomain\Administrator ` -DomainName Labdomain.local -Restart -Force -PassThruOnce you run the above command, it will ask you for the credential for the user you entered. In the above example, we are joining a ... Read More
To create a task using GUI (As shown below image) we need a few settings like the Name of the task, trigger, and Action.Similarly, to create a new task in task scheduler using PowerShell comprises of several settings.Name of the taskThe time when the task to triggerAction − Do we need to schedule a program for execution or send an email on some event trigger.Description − This is optional. You can add a description of the task.Registering task − Final step is to register the created task.Above all actions use different cmdlets but they are part of a ScheduledTasks module. To ... Read More
To start the specific task of the task scheduler using PowerShell, we need to use the Start-ScheduledTask command.When we run the above command, we need to provide the task name.For example, Start-ScheduledTask -TaskName 'FirstTask'When you check the above task status, ExampleGet-ScheduledTask -TaskName 'FirstTask'Output:TaskPath TaskName State -------- -------- ----- \ FirstTask RunningTo start the task on the remote computer, we first need to connect to the CIMSession of the remote computer and we can use the below command.$sess = New-CimSession -ComputerName Test1-Win2k12 Get-ScheduledTask -CimSession $sess -TaskName 'FirstTask' | Start-ScheduledTaskWe can also start the task directly with the command, Start-ScheduledTask using the CIMSession.Start-ScheduledTask -TaskName 'FirstTask' -CimSession $sessRead More
To retrieve the existing tasks in the task scheduler using PowerShell, we can use the PowerShell command Get-ScheduledTask. We can use the Task Scheduler GUI to retrieve the scheduled tasks. To retrieve using PowerShell, use the Get-ScheduledTask command.When we use the above command, it retrieves all the tasks from the different paths/folders as well including the root path. To retrieve tasks created at the root path we need to filter the task path, Get-ScheduledTask | where{$_.TaskPath -eq "\"}If we need to retrieve the specific task then we need to filter the task name, TaskPath TaskName ... Read More
Suppose we have two strings s and t. We have to find the smallest substring in s, where t is also a subsequence of the substring. If that type of substring does not exist, we will return a blank string, and if there are multiple smallest substrings, we will take the leftmost one.So, if the input is like s = "abcbfbghfb", t = "fg", then the output will be fbgTo solve this, we will follow these steps −N := size of Sdp := a new list of size N initialized with infinityfor i in range 0 to N − 1, ... Read More
Suppose we have to implement a class named MedianClass which contains the following methods −add(value) which adds a value to the data structure.median() finds the median of all the numbers currently present in the data structure.So, if we add 5, 3, 8 and find median, the output will be 5.0, then if we add 9 and find the median, the output will be 6.5.To solve this, we will follow these steps −Define priority queue left and rightDefine addNum method, this will take the number as input −if left is empty or num < top element of left, then, insert num ... Read More
Suppose we have an integer n, we have to find the number of positive integers that are less than or equal to n, where the integer numbers at least have a digit occurring more than once.So, if the input is like n = 200, then the output will be 38To solve this, we will follow these steps −Define an array afor initialize x := n, when x is non−zero, update x := x / 10, do −insert x mod 10 at the end of areverse the array aret := nfor initialize w := 1, d := 1, when w < ... Read More