Getting unique information from .CSV, group and average

Question

Ganesh Naik 2021-2-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/747562-getting-unique-information-from-csv-group-and-average

评论： Ganesh Naik 2021-2-24

Test_Data.csv

Hi all,

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2021-2-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/747562-getting-unique-information-from-csv-group-and-average#answer_629569

I didn't look at the data, but you might want to look at splitapply() and findgroups().

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ganesh Naik 2021-2-24

Hi Image Analyst thanks. I will look into the mentioned functions. Also, i have realised that time format is different from dd-mm-yyyy and I need to either read them in the standard format or converting it into unique date-time format.

Is there a way I can combine the consecutive time for the same day (which are spread in different columns) and just bring it as, start and end time for the same day. I can then group or bring all the events in third column into one row as well.

Thanks

请先登录，再进行评论。

Answer 2

Jemima Pulipati 2021-2-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/747562-getting-unique-information-from-csv-group-and-average#answer_628644

Hello,

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.

https://www.mathworks.com/matlabcentral/answers/354238-how-to-extract-specific-rows-with-requirements-from-multiple-csv-files

https://www.mathworks.com/matlabcentral/answers/512842-how-can-extract-specific-value-from-a-column-contains-3-conditions

https://www.mathworks.com/matlabcentral/answers/277516-extracting-rows-from-csv-file-which-contain-only-certain-text

https://www.mathworks.com/matlabcentral/answers/344746-how-to-extract-specific-columns-and-rows-from-a-large-csv-file