Extract values from a data table and create a new table

2 次查看（过去 30 天）
Nuria Andreu
Nuria Andreu 2022-7-6
评论： Nuria Andreu 2022-7-9
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!

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

采纳的回答

Chunru
Chunru 2022-7-7
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
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...

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by