On that note if you want the result to use for later then you just need to capture it in a variable. Then, we use Select-Object to break the value out of the object and just return the data.

All of that output is sent to Measure-Object to calculate the average. If you do not have one then remove the line. Select-Object -Skip 1 is optional and dependent on the presence of a header in your file. You could do something like this Get-Content C: emp ames.csv | Consider the following input column1,column2,column3,column4 I'm fairly new to PowerShell scripting, and I find these kind of actions pretty difficult (to find).Īssuming that you just have a csv full of numbers then instead of using Import-CSV you could just use Get-Content to read the file and extract all the numbers that are present. One more question would be, is there a way to make a calculation with the value that is returned, instead of typing it over and putting it in a calculation as a variable? Import-Csv '$test.csv' | Select 'Frame time' -First 1500 | Measure-object 'Frame time' -ave | Select-Object -expand Average I was able to get an average of values that were in rows, so my question would be either one of these:ġ: How can I calculate the average from all columns that have a value?Ģ: How can I get the values from the columns in rows instead of columns?įrom another CSV file, that I do get correctly, I currently use this code to get the average value over a total of 1500 rows.

However, I want to do this automated in PowerShell and so far I haven't been able to do just this. When you open Excel and select all, excel already gives you an average.

I need all these numbers added together and then divided by the number of columns. For some testing I do for work, a CSV file is created with the numbers all on one row, but a lot of columns.

Change columns to rows in excel