Tag: unique

Python find the unique values in a spesific column. 2d array

Good day. If I have the following array: How can I change the array to only show data from user pear? I want to collect all the values from column 1 of user pear. (12, 14) Or alrternatively how can I find the values that are unique in colum 2, e.g. apples, pear and bannana. And then filter by pear

Add missing timestamps for each different ID in dataframe

date datetime pandas python unique

I have two dataframes (simple examples shown below): df1 shows every timestamp I am interested in. df2 shows data sorted by timestamp and ID. What I need to do is add every single timestamp from df1 that is not in df2 for each unique ID and add zero to the value column. This is the outcome I’m intereste…

frequency of unique values for 2d numpy array

arrays count numpy python unique

I have a 2-dimensional numpy array of following format: now how to print the frequency of unique elements in this 2d numpy array, so that it returns count([1. 0.]) = 1 and count([0. 1.]) = 1? I know how to do this using loops, but is there any better pythonic way to do this. Answer You can use numpy.unique(),…

Pandas dataframe get unique value of a column

dataframe pandas python unique

I’m trying to get the unique available value for each site. The original pandas dataframe is with three columns: Site Available Capacity A 7 20 A 7 20 A 8 20 B 15 35 B 15 35 C 12 25 C 12 25 C 11 25 and I want to get the unique available of each site. The desired table

How can I handle “Reindexing only valid with uniquely valued Index objects”

dataframe pandas python reindex unique

I have a dataframe of names (df): And a schedule dataframe (df1): I pivoted df1 (df1_pivoted) to put assignments in the df1 columns: I then try to add the names back in, but I can not figure out how to deal with the “Reindexing only valid with uniquely valued Index objects” error. I presume it is …

Python: Check for unique characters on a String

character python string unique

I’m asking the user to input a keyword and then remove any duplicate characters. Example: Input: balloon Output: balon I’ve tried this solution: List of all unique characters in a string? but it marks it as a syntax error. Any ideas? Answer For your answer, order is important. Here is a one line s…