Getting unique information from .CSV, group and average
10 ビュー (過去 30 日間)
Ganesh Naik 2021 年 2 月 17 日
コメント済み: Ganesh Naik 2021 年 2 月 24 日
I have this .CSV file (attached) where I need to group and compute the average value from the information from the first column. Precisely, I need to group all 08T into one group, 07T into one group etc (05T, 04T) and compute the average from third column.
Any help in this regard is highly appreciated.
回答 (2 件)
Image Analyst 2021 年 2 月 22 日
I didn't look at the data, but you might want to look at splitapply() and findgroups().
Jemima Pulipati 2021 年 2 月 20 日
From my understanding, you want to extract only some row and column values from a .csv file and perform some manipulations on the retrieved data.
The contains() function can be used to check if a specific pattern is present in the given string.
Te following answers from the community might help you in understanding how to extract and work on data basing on specific conditions from a .csv file.
Find more on Characters and Strings in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!