So I’m trying to make this program that will ask the user for input and store the values in an array / list. Then when a blank line is entered it will tell the user how many of those values are unique. I’m building this for real life reasons and not as a problem set. … Read more
I have a pandas dataframe. I want to print the unique values of one of its columns in ascending order. This is how I am doing it: import pandas as pd df = pd.DataFrame({‘A’:[1,1,3,2,6,2,8]}) a = df[‘A’].unique() print a.sort() The problem is that I am getting a None for the output. 8 Answers 8
As I can understand documentation the following definitions are equivalent: create table foo ( id serial primary key, code integer, label text, constraint foo_uq unique (code, label)); create table foo ( id serial primary key, code integer, label text); create unique index foo_idx on foo using btree (code, label); However, a note in the manual … Read more
I need to find unique rows in a numpy.array. For example: >>> a # I have array([[1, 1, 1, 0, 0, 0], [0, 1, 1, 1, 0, 0], [0, 1, 1, 1, 0, 0], [1, 1, 1, 0, 0, 0], [1, 1, 1, 1, 1, 0]]) >>> new_a # I want to get to array([[1, … Read more
I would like to set up a table in PostgreSQL such that two columns together must be unique. There can be multiple values of either value, so long as there are not two that share both. For instance: CREATE TABLE someTable ( id int PRIMARY KEY AUTOINCREMENT, col1 int NOT NULL, col2 int NOT NULL … Read more
I have a ksh script that returns a long list of values, newline separated, and I want to see only the unique/distinct values. It is possible to do this? For example, say my output is file suffixes in a directory: tar gz java gz java tar class class I want to see a list like: … Read more
This question already has answers here: Generate three different random numbers [duplicate] (2 answers) Closed 8 years ago. I know how to generate a random number within a range in Python. random.randint(numLow, numHigh) And I know I can put this in a loop to generate n amount of these numbers for x in range (0, … Read more
This question already has answers here: Pandas ‘count(distinct)’ equivalent (10 answers) Closed 3 years ago. I need to count unique ID values in every domain. I have data: ID, domain 123, ‘vk.com’ 123, ‘vk.com’ 123, ‘twitter.com’ 456, ‘vk.com’ 456, ‘facebook.com’ 456, ‘vk.com’ 456, ‘google.com’ 789, ‘twitter.com’ 789, ‘vk.com’ I try df.groupby([‘domain’, ‘ID’]).count() But I want … Read more
Assuming I have the following: var array = [ {“name”:”Joe”, “age”:17}, {“name”:”Bob”, “age”:17}, {“name”:”Carl”, “age”: 35} ] What is the best way to be able to get an array of all of the distinct ages such that I get an result array of: [17, 35] Is there some way I could alternatively structure the data … Read more
Is there a built-in that removes duplicates from list in Python, whilst preserving order? I know that I can use a set to remove duplicates, but that destroys the original order. I also know that I can roll my own like this: def uniq(input): output = [] for x in input: if x not in … Read more
