The index and find functions return the position of a character or a substring inside a string. They both take a single parameter, that is required. The two additional parameters: __start and __end are optional.
Continue readingFind an Index of an Item in a List in Python
The index function returns the position of an item in a list. The function takes up to three parameters. One of them is required and the other two are optional.
Continue readingMultiply Each Element of a List Python
When you multiply each element of a list, you create a new list with each value from the original list multiplied by a specific number.
Continue readingConvert Range to a List in Python
If you need to create a list from range, you can use the list constructor. This constructor will convert a range into list elements.
Continue readingConvert Excel Spreadsheet to JSON in Python
To convert an Excel spreadsheet into JSON, first, you have to import the necessary modules: one for reading an Excel file and the second one for converting this data into the JSON format.
Continue readingCheck if a String is Empty in Python
The easiest way to check whether the string is empty is to use the len function. This function is going to return the length of a string.
Continue readingRange of a List in Python
The slice notation in Python is easy to understand. If you want to get a range of a list, you have to give the start and end value.
Continue readingSplit on Whitespace in Python
Whitespace is a character or set of characters that represents vertical or horizontal space.
The split function takes a single optional argument. If you use this function without a parameter, it separates words by single or series of whitespace characters, as long as there is no other character between them.
Continue readingConvert Datetime to Timestamp in Python
To convert datetime to timestamp, first, you have to import the datetime module, assign datetime to a variable and use the timestamp function to convert it into a timestamp.
Continue readingCreate CSV File in PowerShell
To create a CSV file in PowerShell, you can use the following set of commands:
New-Item file.csv
Set-Content file.csv 'First Name,Last Name,Age'
This is how it looks like inside PowerShell.
The first line creates a file and the second one adds three values: First Name, Last Name, Age.
If you open a file in a text editor, the three values are going to be separated by a delimiter. In our case, it’s a comma.
Since the CSV file is just a text file separated by a delimiter (comma in our example), you can easily open this file in a text editor.
It’s the exact text we typed in the terminal.
If you try to add another text with the Set-Content cmdlet, the value that you added earlier will be overwritten at the first line.
Instead, we are going to use a different cmdlet, called Add-Content.
Add-Content file.csv 'John,Doe,54'
Add-Content file.csv 'Emilia,Plater,25'
Two new rows are added. Each row is added after the previous one. Therefore the rows are inserted into rows 2 and 3.
You can open this file in Excel, and you are going to get each value separated by a comma inside a different cell unless you changed the default separator.
Create the file using the foreach loop
Instead of inserting one line per one command, you can use the foreach loop. First, you have to use Set-Content to create a file and add a header, then it adds values from the list using the foreach loop.
Set-Content file.csv 'First Name,Last Name,Age'
$people = @(
'John,Doe,54'
'Emilia,Plater,25'
)
$people | foreach { Add-Content file.csv -Value $_ }
The result of this example is the same as before.
Checking the CSV file
We created a CSV file. Now, we can check its structure with the Import-CSV cmdlet.
Import-Csv file.csvThe contents of the file are printed on the terminal, so we can be sure that the structure is correct.
