Скачать с ютуб Turn Multiple CSV Files Into One Whilst Appending a File Name Column в хорошем качестве

Turn Multiple CSV Files Into One Whilst Appending a File Name Column

This video looks at how to quickly collate multiple CSV files in to one file. As well as the basic collation we also append the original filename into a new column in order to keep the source file names visible. There are many ways to achieve this result, today we are doing this in Powershell. The advantage of Powershell is that anyone using windows can run this code without having to run additional installs (such as Python). If you find this video useful please do give us a thumbs up and subscribe to the channel to see more data hacks in the near future. Do you have a data issue your struggling with? Leave us a comment and we will do our best to make a tutorial that tackles the issue. The following code is as described in the video : Tells Powershell Where Your Original CSV Files Are $folderPath = "C:\ADD YOUR INPUT FILE PATH HERE" Tells Powershell Where To Output The New CSV and What To Call It $outputFilePath = "C:\ADD YOUR OUTPUT FILEPATH HERE\combined.csv" Goes To Collect All CSV Files $files = Get-ChildItem -Path $folderPath -Filter "*.csv" Creates Empty Array To Hold Dataframes $dataframes = @() Goes To Each CSV and Adds Dataframes to the Array foreach ($file in $files) { $df = Import-Csv $file.FullName Adds a new column with the original file name $df | Add-Member -MemberType NoteProperty -Name "OriginalFileName" -Value $file.Name $dataframes += $df } Combines All Dataframes Into One $combinedDf = $dataframes | ConvertTo-Csv -NoTypeInformation | ConvertFrom-Csv Export the combined dataframe to a new CSV file with the original column headings and adds a new column with the original filename $combinedDf | Export-Csv -Path $outputFilePath -NoTypeInformation -Encoding UTF8