filter data based on row value(text) ?

조회 수: 2 (최근 30일)
MUKESH KUMAR
MUKESH KUMAR 2020년 6월 3일
편집: Mohammad Sami 2020년 6월 3일
I had data similar to shown in image1 and want to exteract data for all data for first column for all rows like image2, image3.....so on for all individual routes of column one.
how to filter data based on text values. Sample data is attached in excel file
Here is further followup question after this,
if first column has time varying throughout the day time of 24hr then how can I distribute this data with probability distribution having probality in night is higher during 10PM to 5AM and low in day time.
thanks
  댓글 수: 1
Mohammad Sami
Mohammad Sami 2020년 6월 3일
편집: Mohammad Sami 2020년 6월 3일
Matlab supports various string comparison options.
contains Determine if pattern is in strings
matches Determine if pattern matches strings
endsWith Determine if strings end with pattern
startsWith Determine if strings start with pattern

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by