This tag is for questions involving values which are only one of its kind; unlike anything else.
Questions tagged [unique-values]
173 questions
0
votes
2 answers
Pandas count unique values for list of values
I am trying to figure out, how to count unique values in some column depending on another value. My DataFrame looks like this:
id_user id_track
1 1
1 2
1 4
3 1
3 …
tech2nick
- 93
- 1
- 11
0
votes
1 answer
0
votes
1 answer
Trying to group a tree exported from command prompt
In excel macro, i am trying to get numbers to group as follows.
1
1
2
2
5
5
5
1
1
7
7
7
7
1
1
My data is in the format above. I need the numbers that are next too each other need to group.
For example
1 Grouped
2 Grouped
5 Grouped
1 Grouped
7…
Andrew Watters
- 1
- 2
0
votes
0 answers
Java, collection with unique values
I have a task to do for my classes. I need a collection to keep unique values, but java.util.Set is not enough for me.
What I have to do - if I add words "dogs" and "cats" to collection and afterwards I try to add "dog" and "cat", in my collection…
foxbuur
- 169
- 1
- 9
0
votes
0 answers
R data.table: Sum column with multiple values per row
I have a dataset that has columns with semi-colon separated values that represent countries like this:
row countries weights
1: 22;3 1.254
2: 5 0.54
3: 6;8;123 2.65
4: 16 0.35
5: 77;21;1 0.98
6: 89 1.74
etc.
with data.tables, I can sum per unique…
Mario
- 2,393
- 2
- 17
- 37
0
votes
0 answers
mysql assign list of values to foreign key pair
My question has to do with structuring my database
Basically, I have 20+ tables all with 10+ million records of various things. I, however, am not sure what to do with the following information
I have an overarching Id, main_id, that is associated…
Matt
- 43
- 1
- 7
0
votes
4 answers
Trying to Print Array without Repeating Numbers
I have a programming assignment where I am tasked with the following:
I am taking two int values (x and y) and creating two different arrays: the first (size x) will print an array starting from x and descending down to 1. The second (size y) will…
user5840106
0
votes
2 answers
Force user to select different values in multiple h:selectOneMenu showing same lists
I am relatively new to JSF and Primefaces. I have a page in which I have three selectOneMenu displaying the same set of values from a map. I would like to make sure that the user selects different values for the three drop downs. I have achieved…
Ditto
- 43
- 2
- 5
0
votes
2 answers
Count unique values with criteria
For this Google spreadsheet I would like to do the following:
Count the Unique "Provider User IDs" (column C) that meet the following criteria:
Column H = "Incomplete" OR "Provider Missed"
Column K = 3/24/14 < Value <= 4/30/14
Column X = "School…
Jeremy Loya
- 1
- 2
0
votes
0 answers
How to find out distict value from table and then count of every distict value with respective column in mysql
data_table
col_1 col_2 col_3 col_4
car train plane book
bike pen car Null
tempo train car laptop
Null train tempo book
expected output
distinct_value count_col_1 count_col_2 count_col_3…
user3074158
- 21
- 7
0
votes
4 answers
mysql statement wont insert
Hey guys I've searched for answers through the forums but to no avail so I'm using MySql and I'm trying to insert statements for certain tables and they aren't going into the tables and I'm getting errors like "Msg 8152, Level 16, State 14, Line…
DarkBlue
- 19
- 6
0
votes
2 answers
Remove duplicate from list which is used as value in dictionary
I have a dictionary with values as a list. I would like to remove duplicates from this list.
{(2,): ['a', 'a', 'b', 'b'], (3,): ['c', 'c'], (1,): ['a', 'b', 'b'], (4,): ['b', 'c', 'd']}
This dictionary should return {2:['a','b'], 1:['a','b'],…
Kubix
- 79
- 1
- 8
0
votes
1 answer
How to change values
In Excel I have a range of numbers that need to equal something. So I have the number totaled in a column showing as below, then in the next column, depending on the range, I need it to equal something else. (1-8) =.25; (9-15)=.5; (16-19)=.75…
0
votes
0 answers
SQL - Print sum of select contents in a column
This is to PRINT, from dbo.Emp, the total number of records, per unique value
I did it this way:
SELECT field1, COUNT() records
FROM dbo.Emp
GROUP BY field1
HAVING SUM()
PureData1
- 71
- 9
0
votes
2 answers
SQL - Creating Additional Lines of zero value data (Cross Join type?)
I'm trying to figure out how to get a query to work. I kind of want to do a cross join, but not really a cross join type query.. nor is it a full join (I don't think) So I'm throwing it to the community for input.
I have table 1:
Acct AcctDesc …
Dregalia
- 61
- 1
- 5