Extract values from a data table and create a new table

2022 7 6
2 个回答
回答已采纳
更新时间：2022 7 9
2 次查看（30 天）

0 个投票

Hello! I have a data file with multiple data points including date and precipitation values (range from 0.1 inches to 2 inches).
I want to extract all of the precipitation values over 1 inch and store them in a new table with its proper date. Anyone has some tips or ideas on how to do this? I gave up after multiple tries.
Thank you in advance!

2 个评论
显示 无 隐藏 无

Chunru
Chunru 2022-7-7
upload a sample data in readable format such as .mat or .csv
Nuria Andreu
Nuria Andreu 2022-7-7
Data = readtable('Sta_Teresa.csv');
%like this?

请先登录，再进行评论。

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

 采纳的回答

Chunru
Chunru 2022-7-7
Ran in:

0 个投票

Ran in:
T = readtable("https://www.mathworks.com/matlabcentral/answers/uploaded_files/1057240/Sta_Teresa.csv");
T1 = T(T.PRCP > 1, :)
T1 = 94×4 table
STATION NAME DATE PRCP _______________ _______________________________ __________ ____ {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 07/16/0002 1.11 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 07/19/0002 1.04 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 06/27/0004 1.06 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 07/28/0006 1.55 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 07/31/0006 1.91 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 08/01/0006 2.03 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 08/01/0006 3.06 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 08/02/0006 1.15 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 08/16/0006 1.14 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 08/19/0006 1.89 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 09/03/0006 1.45 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 09/03/0006 1.02 {'USC00298127'} {'SANTA TERESA AIRPORT, NM US'} 09/04/0006 1.16 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 09/04/0006 1.28 {'US1NMDA0159'} {'SANTA TERESA 1.0 WNW, NM US'} 08/01/0007 1.38 {'US1NMDA0092'} {'SANTA TERESA 0.5 SSW, NM US'} 08/02/0007 1.56

更多回答（1 个）

dpb
dpb 2022-7-7

0 个投票

What did you try? Have you looked at the "Getting Started" section on array indexing/addressing; specifically logical indexing?
PLevel=1; % the magic constant -- don't bury in code, use variables
tPrecipGreater=tPrecip(tPrecip.PRCP>Plevel,:);
That's it...

类别

在 帮助中心 和 File Exchange 中查找有关 Web Services 的更多信息

产品

版本

R2021b

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by