I have the 1st column that is around 4920 different chemical compounds. For example: 0 Ag(AuS)2 1 Ag(W3Br7)2 2 Ag0.5Ge1Pb1.75S4 3 Ag0.5Ge1Pb1.75Se4 4 Ag2BBr … … 4916 ZrTaN3 4917 ZrTe 4918 ZrTi2O 4919 ZrTiF6 4920 ZrW2 I have the 2nd column that has all the elements of the periodic table numerically listed atomic number 0… Read More How can I label a column of strings into numbered groups based on another column containing substrings?

I have data from a questionnaire that has a column for year of birth. So the range of data was too large and my mapping became confusing. I’m now trying to take the years, group them up by decade decade, and then chart them. But I don’t know how to group them. my data is… Read More how to count and group categorical data by range in r

I have a categorical column in my dataset which has around 20 or more categories. Now I want to create seperate dataset for all these categories. Example: if the category is A, B, C, …. then I need table A containing A data, table B containing B data etc. >Solution : A classic use of… Read More Splitting data in SAS by categorical column

I am trying to identify the categorical columns of a dataset so that I can convert them to numerical columns. I have looked at this, this, and this, among others but I still seem to be doing something wrong. EDITED My code: import pandas as pd from sklearn.linear_model import LogisticRegression from sklearn.model_selection import train_test_split from… Read More Identifying the categorical columns of a dataframe

Let’s say I have have a dataframe with a column called animals. The entries look as followed: ‘A’, ‘A’, ‘A’, ‘B’, ‘B’, ‘B’, ‘C’, ‘C’, ‘E’, ‘F’, ‘G’, ‘H’, ‘I’. I want to change the entries ‘E’, ‘F’, ‘G’, ‘H’ and ‘I’ to another unified entry called ‘D’. What is the best way to transform… Read More Change certain categorical variables to a unified entry

I have the following df df = pd.DataFrame({‘Cat’:[‘tq’,’tb’,’ta’,’tb’,’ta’,’tq’,’tb’,’tq’,’ta’], ‘col1’:[‘a’,’a’,’a’,’b’,’b’,’c’,’c’,’c’,’a’], ‘col2’:[‘aa’,’aa’,’aa’,’aa’,’ba’,’ba’,’cc’,’cc’,’cc’], ‘val’:np.random.rand(9)}) I would like to create the following rankings: df[‘Cat’] = pd.Categorical(df[‘Cat’],[‘tb’,’tq’,’ta’]) However, when I try to do a group by sum: df2 = df.groupby([‘col1′,’Cat’,’col2′])[‘val’].sum() I end up with a 27 row table instead of the desired 8 rows that would occur where I to… Read More Grouping a pandas dataframe with categorical strings