This tag is for questions involving values which are only one of its kind; unlike anything else.
Questions tagged [unique-values]
173 questions
1
vote
1 answer
Count of how many times a unique value appears across all columns and rows of a dataset?
I have unique IDs in rows where columns are the IDs of their 'sent' friends. To get a count of 'received' friends, I need to get a count for how many times an ID appears across all columns and rows of the dataset. This is easy in R, but I'd like to…
Marcus
- 13
- 3
1
vote
1 answer
Unique Element Error from list dictionary python
I am trying to do aspect-based sentiment analysis. When I try to find the aspect as well as opinion using a dictionary, I got some of the aspects pair many times in the dictionary. My code is:
aspects_main = []
feature_main =[]
feautures_term_main…
Samrat Alam
- 558
- 3
- 19
1
vote
1 answer
SQL - Select non duplicates column values
I have the following SQL table containing a group ID, and the users that needs access to the groups. I have 3 types of users, but if it is the same user in all 3 types, then I only need to select 1 and not all 3.
This is my table:
And this is the…
OJ Slott
- 75
- 6
1
vote
3 answers
How to get unique values/elements of a column?
I am trying to get the unique values of a column from a tab. The values are repeated and the file has 1,000+ lines, I just want to have the names of the values, not all, and the ones that are repeated. I'm working on my code, but when I do "RUN" it…
Valy1004
- 43
- 5
1
vote
2 answers
Python pandas nunique() datatype
I have a simple pandas DataFrame, let's call it ratings:
ratings = pd.read_csv("ratings.csv", header=0, delimiter=",")
print(ratings)
userId movieId rating
1 1 4.0
1 3 4.5
2 6 4.0
3 2 …
Tran Tam
- 23
- 1
- 5
1
vote
1 answer
VBA required for AutoFilter XLFilterValues Array
I'm new to VBA and I'm trying to create a macro that will filter a column on one sheet (Rules) based on the cell value in another which contains the unique values on that column. The unique values are separated by " & ":
Example, a cell may contain…
FrazNic
- 11
- 1
1
vote
1 answer
Collecting all the indices of unique elements in CSV file and populating them in a row
I have a set of data in CSV file like this:
[['1', '1.5', '1', '2', '1.5', '2'],
['2', '2.5', '3', '2.5', '3', '2.5'],
['3', '2.5', '1.5', '1', '1', '3'],
['1.5', '1', '2', '2', '2', '2.5'],
['1.5', '1.5', '1', '2.5', '1', '3']]
I want to find…
Supernova
- 25
- 4
1
vote
2 answers
How do I get a unique set of values for a specific key in a list of dictionaries?
I'm using Python 3.8. If I want to get a unique set of values for an array of dictionaries, I can do the below
>>> lis = [{"a": 1, "b": 2}, {"a": 3, "b": 4}]
>>> s = set( val for dic in lis for val in dic.values())
>>> s
{1, 2, 3, 4}
However, how…
Dave
- 15,639
- 133
- 442
- 830
1
vote
1 answer
How to find out unique values and number of unique values in a column in a dataset in Orange?
How to find out unique values and number of unique values in a column in a dataset in Orange? I have looked in the widgets Data Info and Feature Statistics, this information is not displayed.
userlogfern
- 55
- 6
1
vote
1 answer
Unique values two columns combobox vba
I need to display two columns A and B listed in a combobox with unique values. So if two rows have the same A but not the same B, it is not a duplicate, both column need to be duplicate. I found a code that list one column (A) with unique values but…
Lawrence231
- 31
- 7
1
vote
0 answers
EXCEL - pulling unique values from a range that fit specific criteria
I am using the following array formula in excel to pull unique values from a range.
{=INDEX($N$2:$N$21, MATCH(0,COUNTIF($A$385:A399, $N$2:$N$21), 0))}
That works fine, however I want to pull specific values based on criteria.
The data I am working…
Chrispy243
- 23
- 2
1
vote
1 answer
Recode multiple numeric values into new values in R
I want to recode many unique numeric values (>3000) of one column into new values.
The unique values appears many times in the column!
I am using R and all available functions like recode need the definition of all new values! Is there a way to…
1
vote
4 answers
How to get multiple values from a for loop?
I have a list of records from a column, the list is named as dates. I am trying to get different dates out of the list. The list have many repetitive dates, such as 1/1/2010,1/1/2010, …. but there are different dates too.
But if i use:
for date in…
widget
- 945
- 3
- 13
- 22
1
vote
4 answers
How do I extract unique values from multiple columns and use them to populate one column?
I have a large table with lots of data, but what I'm looking at is six columns of that table - the names of people who went on a particular job together. Something like this:
+-------+--------+--------+-------+--------+-------+
| Name1 | Name2 |…
RolloTreadway
- 33
- 1
- 5
1
vote
1 answer
MS Access Count unique values of one table appearing in second table which is related to a third table
I am working with my lab database and close to complete it. But i am stuck in a query and a few similar queries which all give back the similar results.
Here is the Query in design mode
and this is what it gives out
This query is counting the…
junaid bashir
- 17
- 3