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
5 answers
iterate over rows in pandas and count unique hashtags
I have a csv file containing thousands of tweets. Lets say the data is as follows:
Tweet_id hashtags_in_the_tweet
Tweet_1 [trump, clinton]
Tweet_2 [trump, sanders]
Tweet_3 [politics, news]
Tweet_4 [news, trump]
Tweet_5 [flower,…
Arsalan
- 333
- 4
- 14
1
vote
1 answer
Get unique values in matrix with Matlab
I'm looking for fastest way to get unique values in matrix with Matlab! I have a matrix like this:
1 2
1 2
1 3
1 5
1 23
2 1
3 1
3 2
3 2
3 2
4 17
4 3
4 17
and need to get…
Sina
- 575
- 1
- 5
- 23
1
vote
1 answer
Extract unique values from a range in excel while disregarding specific values
I originally had an Excel spreadsheet which was used to record values of JOB LOT IDs (>10000). I used the following array formula -…
JGPinMA
- 13
- 4
1
vote
1 answer
ElasticSearch - Return unique result by field values
I have 3 "places" having each a type and a location:
PUT places
{
"mappings": {
"test": {
"properties": {
"type": { "type": "keyword" },
"location": { "type": "geo_point" }
}
}
}
}
POST places/test
{
…
woshitom
- 4,811
- 8
- 38
- 62
1
vote
0 answers
How To Count Unique Values Based On Another Columns cell value being between times
I am pulling my hair out on what I thought would be a simple formula.
I am wanting to figure out how many customers I have, qty of items sold and $ between the different times of the day.
For Cust# i have been trying to use the following (changing…
helpsk
- 11
- 2
1
vote
2 answers
Copying Unique values realtime
I have a spreadsheet with all invoices which include vendor number, around 9000 rows. Most of those invoices are for a handful of vendors.
I want to get the vendors exist in the column and copy them in another sheet, but in real time. As I am trying…
Islam Aly
- 11
- 3
1
vote
2 answers
counting unique row values in excel
I have product list like this. I have only product name list
Apple 1
Apple 1
Apple 1
Orange 2
Orange 2
Orange 2
Mango 3
Mango 3
Pineapple 4
Pineapple 4
Pineapple 4
Pineapple 4
Pineapple …
Rahul
- 21
- 4
1
vote
2 answers
Filling empty cells of a matrix with random values in java
I am trying to make a matrix in Java that is going to be filled with random values only in that positions that are empty. I am trying these code but it doesn't work.
I made two nested for loops, one for the rows and one for the columns. And for…
jasmin
- 19
- 5
1
vote
1 answer
Sum unique values based on another column
I have four values: Name, Maturity, Hasinteracted?, SizeofName
Entity (Constant) - represents the name of the entity.
Maturity (Variable) - In months, how long have they been active with us (i.e. 1 would be one month etc)
Hasinteracted? (True,…
Ohm
- 13
- 4
1
vote
4 answers
print unique values from array
I need to get the unique values of the first array index and this is how I tried.
public class Array {
public static void main(String[] args) {
int[][] array = {
{100, 12 , 0, 3},
{100, 177, 0, 3},
…
user4605225
1
vote
1 answer
Find all duplicate values in one column and combine all its values
So I got this excel file with a lot of data which is why I want to avoid doing all this manually. Basically what I want to do is find all values that is the same in one column and then combine all it's values to one row.
If I have this data in a…
Oliver
- 119
- 1
- 3
- 14
1
vote
2 answers
Unique numbers depending on date
I think I have been going at this a little bit to long and therefore maybe have become blindsided. I am looking for a way to identify the total number of orders given that the date is not the same. Each order can have several lines due to shipping…
Dave
- 11
- 2
1
vote
1 answer
Is it possible to get the values for de y-axis in gnuplot?
I need the calculated y-values by gnuplot. How do I get those values.
In this example, de values 100 and -700.
I looked between all default variables gnuplot but could not find it.
Let me try to explain:
First an example
Here you can see the…
Con
- 197
- 2
- 10
1
vote
4 answers
Counting unique values across variables (columns) in R
I have a large dataset with repeated measures over 5 time periods.
2012 2009 2006 2003 2000
3 1 4 4 1
5 3 2 2 3
6 7 3 5 6
I want to add a new column, which is the number of unique…
user3251223
- 265
- 1
- 7
- 15
1
vote
3 answers
Doubt in action script for Flex: getting unique elements from an ArrayCollection
I have an ArrayCollection as mentioned below.
private var initDG:ArrayCollection = new ArrayCollection([
{fact: "Order #2314", appName: "AA"},
{fact: "Order #2315", appName: "BB"}
{fact: "Order #2316",…
Nirmal Singh Raja Reegan
- 367
- 1
- 5
- 13