Working with CSV's in Windows Powershell

Powershell is a relatively unique and very powerful command line interface (CLI) and with Windows 10 is now the default shell for Windows. In this video we'll explore some of the basics of powershell and specifically look at how to use powershell to analyze CSV data.

Powershell is uniquely useful for this task due to its ability to handle data as objects and because of the native support for both CSV and JSON input and output. The ability to filter, sort and format data is also a very strong tool that is both easy to use and understand.

We will also look at using the Powershell ISE (included with Windows) that provides a useful scripting environment for building scripts and testing commands as well as learning more about the capabilities of powershell.

[ThisGuyDakota]

I know this has been out for a while, but for future viewers I'd argue that Powershell actually IS a scripting language more than just a command line. It has the potential to do what most scripting languages can (maybe less efficiently). You can do things like API calls, remote administration, GUI design (this one uses a fair bit of .NET), and even things like multithreading using jobs, runspaces, etc.

[BenevolentVoid]

In the future, it would be cooler if your video feed was in the bottom right, not obscuring the terminal output of the powershell ISE, This made it a bit hard to see the results pane you were discussing quite a bit.

[EightCounts]

CSV objects are imported as strings. Powershell doesn't automatically convert string to number so this is why the -lt 400 filter was failing.


Where-Object { ($_.Melting_Point -as [int]) -lt 400 }

[sushantyadav]

this is pretty useful for beginners with scv

[khabrio]

Man thankyou so much for giving me an idea, keep it up ✌