filmov
tv
Analyze Data with PowerShell | U.S. Presidential Election 2020 Dataset
Показать описание
Most of my videos on PowerShell have centered around language techniques. Let's change gears a little bit and do something a bit more practical, like data analysis. While perusing the Internet, I discovered a New York Times API that provides 2020 U.S. election data in a JSON format. Let's use PowerShell to download that data locally and then load it and run some queries against it!
PowerShell natively offers a ConvertFrom-Json command. Quite simply, this command accepts a JSON string as input, and in return, it provides a PowerShell object exposing the various properties on the JSON data structure.
Where-Object can be used to filter PowerShell objects using a specified "filter script." The filter script is applied to each object in the pipeline.
Add-Member is a powerful command that enables you to add properties and methods to PowerShell objects. In this video, we'll use Add-Member to add a new calculated property to each object in an array. We'll take the UNIX timestamp in microseconds and turn it into a new property that contains a more human-friendly System.DateTime object.
Producer: Trevor Sullivan
#Microsoft #PowerShell #Analytics
PowerShell natively offers a ConvertFrom-Json command. Quite simply, this command accepts a JSON string as input, and in return, it provides a PowerShell object exposing the various properties on the JSON data structure.
Where-Object can be used to filter PowerShell objects using a specified "filter script." The filter script is applied to each object in the pipeline.
Add-Member is a powerful command that enables you to add properties and methods to PowerShell objects. In this video, we'll use Add-Member to add a new calculated property to each object in an array. We'll take the UNIX timestamp in microseconds and turn it into a new property that contains a more human-friendly System.DateTime object.
Producer: Trevor Sullivan
#Microsoft #PowerShell #Analytics
0:34:28
Analyze Data with PowerShell | U.S. Presidential Election 2020 Dataset
0:09:46
Start Data Analysis with PowerShell: The Windows Tool You Already Have
0:07:55
Text Analysis Made Easy with PowerShell: Build Your Own Analyzer
1:08:19
PowerShell Meets DuckDB Integrate, Query, and Analyze Data Seamlessly
0:13:43
PowerShell Tutorials : Data Tables
0:03:29
Designing and Implementing Big Data Analytics: Managing Big Data with PowerShell
0:06:31
Comparing data in PowerShell
0:22:42
Hunting Powershell Obfuscation with Linear Regression | Threat Hunting & Incident Response Summi...
0:40:19
Upgrade Pathways to Data Factory in Fabric
0:08:27
AI Data Analysis with ChatGPT: Automate Insights & Generate PowerShell/JS for External Use
0:59:59
PowerShell: Part 2: Audit and Compliance Data Acquisition with PowerShell
0:01:22
Sql or powershell data to html report to email using powershell
0:07:32
Analyzing PowerShell Payloads - Part 1
0:01:59
Analyze PowerShell Scripts in a PowerShell Notebook
0:54:57
Stupid PowerShell Tricks
0:11:15
How to Analyze a Malicious Powershell Script & Fileless Malware
0:48:16
Working with Data File Formats in PowerShell - Guy Leech - PSConfEU 2024
0:25:03
PowerSIEM - Analyzing Sysmon Events with PowerShell - Dynamic Malware Analysis
0:00:54
5 Tricks to Become an Excel Wizard
1:55:07
Excel and PowerShell: A Powerful Data Duo
0:10:57
10 Million Rows of data Analyzed using Excel's Data Model
0:25:25
KringleCon 2018 - Chris Davis, Analyzing PowerShell Malware
0:52:46
Powershell basics and intro to Windows event log analysis with Powershell
0:14:06
Powershell | Filter/Extract specific logs from log file | Tutorial 1
Комментарии