panJames
asked on
Density of selected values within file
Hello experts!
Please have a look at the numbers attached to the code.
First number is amount of indexes.
The second number is index itself.
Indexes are valued from 0..7.
So for example:
19, 4
means that we have nineteen indexes with value of 4.
My task is to analyze the density of these indexes.
These density types should be calculated and taken into consideration:
(I want to find index values and position borders they appear)
- single indexes
- couples of indexes
- triples of indexes
So if we look for single indexes we should find out that we have high density of
indexes = 4 (look at line no.2) and indexes = 0 (look at line no. 6).
If we look for triples of indexes we should find out that we have high density
of indexes 0, 1, 7 (from line no. 5 to 66).
Search for couples will be similar as for triples.
How can I make such analysis in a smart way?
Is there any mathematical tool to do such things?
Thank you
panJames
Please have a look at the numbers attached to the code.
First number is amount of indexes.
The second number is index itself.
Indexes are valued from 0..7.
So for example:
19, 4
means that we have nineteen indexes with value of 4.
My task is to analyze the density of these indexes.
These density types should be calculated and taken into consideration:
(I want to find index values and position borders they appear)
- single indexes
- couples of indexes
- triples of indexes
So if we look for single indexes we should find out that we have high density of
indexes = 4 (look at line no.2) and indexes = 0 (look at line no. 6).
If we look for triples of indexes we should find out that we have high density
of indexes 0, 1, 7 (from line no. 5 to 66).
Search for couples will be similar as for triples.
How can I make such analysis in a smart way?
Is there any mathematical tool to do such things?
Thank you
panJames
1, 5
19, 4
2, 6
1, 2
1, 1
18, 0
1, 1
1, 0
1, 7
3, 0
1, 1
1, 7
1, 0
1, 1
1, 7
1, 0
1, 1
1, 7
5, 0
1, 1
1, 0
1, 7
2, 0
1, 1
1, 7
1, 1
2, 0
1, 7
5, 0
1, 1
1, 7
1, 0
1, 1
2, 0
1, 7
2, 0
1, 1
1, 7
2, 0
1, 1
2, 0
1, 7
1, 0
1, 1
1, 0
1, 7
1, 1
1, 7
3, 0
1, 1
1, 7
1, 1
4, 0
1, 7
1, 1
1, 7
1, 1
1, 7
2, 0
1, 1
1, 7
4, 0
1, 1
1, 7
2, 0
1, 7
1, 5
2, 6
1, 5
2, 6
If you don't have Access, you most likely have Excel (or OpenOffice or something that does the same thing). These programs will open the file perfectly (they are built to understand the commas as separating cells). They can do quite a bit of analysis with built-in functions and you can write scripts to do anything that computers are capable of doing.
In a string like 0,1,7,0,1,7,0,1,7, 0. Should the 0,1,7 and 1,7,0 triples both be counted (3 each)?
Does 19,4 indicate a bunch of triples of 4?
The required analysis is not yet clear.
In a string like 0,1,7,0,1,7,0,1,7, 0. Should the 0,1,7 and 1,7,0 triples both be counted (3 each)?
Does 19,4 indicate a bunch of triples of 4?
The required analysis is not yet clear.
ASKER
Flyster: Thank you for your answer.
What I need here is algorithm to solve problem.
panJames
What I need here is algorithm to solve problem.
panJames
Is 4,0 essentially the same as 0,0,0,0? So do you need to look at triples like 0,0,0? We need more specifications before we can help with algorithms.
Also, what platform are you working with? C++, Excel, VBScript, pen and paper, etc
Also, what platform are you working with? C++, Excel, VBScript, pen and paper, etc
ASKER
@TommySzalapski:
"Is 4,0 essentially the same as 0,0,0,0?" <- not really.
I should explain it better.
Values attached describe another file with values inside [values: 0..7]
First file:
0
0
0
0
1
1
2
2
2
it means that in the second file we get:
4, 0
2, 1
3, 2
so the second file is like a summary of the first file.
Algorithm will be using C++
panJames
"Is 4,0 essentially the same as 0,0,0,0?" <- not really.
I should explain it better.
Values attached describe another file with values inside [values: 0..7]
First file:
0
0
0
0
1
1
2
2
2
it means that in the second file we get:
4, 0
2, 1
3, 2
so the second file is like a summary of the first file.
Algorithm will be using C++
panJames
panJames,
Copy the list into Excel and use Data/Text to columns to split the data into 2 columns - Number of Indexes and Index. Having done that set up a small table listing the indexes and use this formula to summarise the results:
=SUMIF($B$1:$B$70,D2,$A$1: $A$70)
It's in the atteched Excel file.
Patrick
panJames-01.xls
Copy the list into Excel and use Data/Text to columns to split the data into 2 columns - Number of Indexes and Index. Having done that set up a small table listing the indexes and use this formula to summarise the results:
=SUMIF($B$1:$B$70,D2,$A$1:
It's in the atteched Excel file.
Patrick
panJames-01.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
22,0
20,1
1,2
1,4
3,5
3,6
20,7
This took all of 5 minutes. If this is what you're looking for, I can provide you with some guidance on how to create the table and query.
Flyster