fifonik / FFMetrics

Visualizes Video Quality Metrics (PSNR, SSIM & VMAF) calculated by ffmpeg.exe
570 stars 22 forks source link

CSV output doesn't appear to have any commas #66

Closed ShortyCM closed 3 years ago

ShortyCM commented 3 years ago

Since there is a 12-file limitation and I have 60 files to process today I have started loading up the 12 that will fit in the project and selected to output the CSV data files so that I can compare them all later. However, the CSV output files don't appear to actually have any commas in them, so the data is not arranged in a fashion that's easily digested. When I load up a CSV file in Excel this is what I see in one of the cells, which appears to be a large number of data entries that should have had commas to separate them, but instead they are all in one cell. The data seems largely unreadable to me due to the lack of proper formatting.

1 5.607279 10.126511 0.996095 0.980712 0.988913 0.997662 0.999687 0.889344 0.995094 0.998022 0.998976 100 1

fifonik commented 3 years ago

As per the project home page, data saved as tab-delimited csv:

The term "CSV" also denotes several closely related delimiter-separated formats that use other field delimiters such as semicolons.[citation needed] These include tab-separated values and space-separated values. A delimiter guaranteed not to be part of the data greatly simplifies parsing. Alternative delimiter-separated files are often[citation needed] given a .csv extension despite the use of a non-comma field separator.

So tabs are used as separators instead of commas. Sure the file can be imported in Excel with no issues.