# Filtering the values of current and voltages based on a criteria

1 view (last 30 days)
Ganesh Kini on 12 Mar 2020
Commented: Ameer Hamza on 3 Apr 2020
I have a list of 1000000 sets of data in a .mat file. it has 5 columns, say A,B,C, Current and voltage. for many sets of data we would be having same current and voltages values. I need to read the file and then I need to filter out and get the values of current and voltage as output based on some condition. How do i do it ? I'm new to matlab. kindly help
The data looks something like this
A B C current voltage
.1 0.33 .99 1 1
0.2 0.34 .100 1 2
0.3 0.35 .101 1 3
0.4 0.36 .102 1 1
0.5 0.37 .103 2 3
0.6 0.38 .104 2 6
0.7 0.39 .105 2 8
0.8 0.40 .106 3 3
0.9 0.41 .107 3.5 3
0.10 0.42 .108 3 3.5
0.11 0.43 .109 3 0
0.12 0.44 .110 3 3.5
0.13 0.45 .111 3.5 0
0.14 0.46 .112 3.5 6
0.15 0.47 .113 3.5 7
How do i print the values of current and voltage by reading each data based on some condition ( condition is not related to current or voltage ) .The condition is with respect to time, and not A,B, C
PS: reading the file is done, I'm getting the proper output. only filtering part is left

Ameer Hamza on 12 Mar 2020
Suppose you have two linear arrays named current and voltage, you can filter them based on a condition as follow.
It filters all values where current is greater than voltage.

Ameer Hamza on 3 Apr 2020
But which variable is time?
Ganesh Kini on 3 Apr 2020
A BC current voltage time
.1 0.33 .99 1 1 1ns
0.2 0.34 .100 1 2 1ns
0.3 0.35 .101 1 3 1ns
0.4 0.36 .102 1 1 2ns
0.5 0.37 .103 2 3 2ns
0.6 0.38 .104 2 6 1ns
0.7 0.39 .105 2 8 3ns
0.8 0.40 .106 3 3 3ns
0.9 0.41 .107 3.5 3 3ns
This an example how it looks. So for time 1 ns i want all the values of current and voltage
but the above matrix is stored in a .mat file.
I need to access the variables by loading the file and then extracting the current and voltage value based on time = 1ns condition
Ameer Hamza on 3 Apr 2020