Stack Overflow
Stack Overflow

Questions tagged [unique-values]

This tag is for questions involving values which are only one of its kind; unlike anything else.

173 questions
0
votes
2 answers

Creating a Function to Count Unique Values Based on Another Column

I have data that look like this. company_name new_company_status A Co.,Ltd Yes B. Inc No PT XYZ No PT DFE, Tbk. Yes A Co.,Ltd Yes PT DFE, Tbk. Yes I want to create a function in python to check every unique company name from…
matilda
  • 1
  • 1
0
votes
3 answers

Autofilling form values in PHP/HTML

In a PHP web page, when flling the form and some of the fields are filled incorrectly, I need to return to the same page and auto-fill all the fields that were prefiously filled by the user. How do I set the values of the fields? I tried using the…
Teddy Woods
  • 9
  • 1
0
votes
0 answers

Changing values or Data Transfer from one mobile to another when they are too away, and no internet is available

Can we change some values (In the Program or Application) or send and receive data from one mobile to another if no internet is available and they are too away from each other, I mean through satellite or some similar?
Zeeshan Ali
  • 13
  • 4
0
votes
0 answers

Highlight Consecutive Cells with same value more than 6 times with conditional formatting

G'day - been trying to solve a highlighting issue when the word 'Regulated Work' appears more than 6 times in a row consecutively using conditional formatting but cant get it quite right. Tried using - =and($4:$13=''Regulated…
Dave
  • 1
  • 1
0
votes
1 answer

Get a unique value range of a rasterlayer

My rasterlayer has a range from 0 to 1. I just want the Pixel values from 0.2 to 0.1 I tried this Code: R<- myraster R[(R<=0.1) & (R>=0.2)] <- NA This is my idea for a range of value. For a single value I don't know. If I use this code I get online…
Maik
  • 1
  • 1
0
votes
1 answer

Unique Values and the corresponding % in the number they appear

I want to achieve something here, the unique values with the corresponding percentage appearance of the values in the column. e.g. I have dataframe df and column prices ,to get the list it will be sth like. print(df.prices.unique().tolist()) it…
Derrick Kuria
  • 159
  • 1
  • 10
0
votes
3 answers

How to get unique values for all variables in a dataset

I'm using Stata. I have a dataset with approximately 1800 observations and 1050 variables. Most of them are categorical variables with a few categories. It looks something like this: ------------------------------------------------------ | id | fh_1…
Joseph
  • 9
  • 4
0
votes
1 answer

ngfor in Filter should display only unique values

I have a Filter in my Angular-Project that loads data from Firebase. Current status in Filter: Name 1: Lea Muster Name 2: Bruno Mustermann Name 3: Lea Muster Name 4: Gabriela Musterfrau Goal: Lea Muster is a duplicate in the data but should be…
user14858919
  • 33
  • 1
  • 4
0
votes
1 answer

how to find the number of occurrences a unique value appears in a list in R using dplyr?

I extracted data from sql in R. The data is in a list. I want to find the number of occurrences each value appears in a column of the list. How would I go about doing this? I'm very new to R. group_by(demo) %>% summarise(unique_value =…
irene123
  • 11
  • 2
0
votes
1 answer

Count unique values, with condition in other column

I have a dataset with orders from multiple days. I would like to map this in a matrix (100 cells by 100 cells) to see where orders appear. I allready added a column to the dataset which determines in which region of the 100x100 matrix the order…
Cornelis
  • 445
  • 3
  • 11
  • 27
0
votes
0 answers

Extract weather values from app.weathercloud.net

Hi all I would like to extract 25.8 value from this html block using xpath the html code is from a weather website, https://app.weathercloud.net/ "

Intensidad de lluvia

o_torrents
  • 1
0
votes
1 answer

Countif Formula to exclude Duplicates

I sought help regarding this once, but I failed to outline my problem. This time I am happy to share the sheet with dummy data in hope it explains my problem a bit better: Link to the sheet My issue is the following: In column E I am counting the…
A.Be
  • 73
  • 5
0
votes
0 answers

Unique Values in the dataset

When you have a data frame that you have created from importing and loading a CSV file and I want to start Data Exploration. I have started Checking for Missing Values and I have decided to deal with these different missing values in a different way…
Celine Ahmad
  • 1
  • 1
0
votes
0 answers

Retrieving unique values only works with a specific sheet open

Having some issue with a simple macro. I want to replace retrieve the unique values of column B in worksheet FLMs and paste it to another sheet. It works fine normally but only when I have the FLMs worksheet open and then run the macro. However, the…
Fastbanana
  • 1
  • 1
0
votes
0 answers

In Excel, how do I count how many time a value is associated with values in an adjacent column?

Greetings and salutations! I have a dataset as below. I need to count the number of times each unique Custom Id value is associated with a pair of Move to Thaw/Move to Freeze (known as freeze thaw cycles). For example, the first Custom ID of…
RaleighWalker
  • 17
  • 5
1 2 3
…
11 12