Skip to content

Splitting object data into new columns in dataframe

i have a dataframe with column business_id and attributes with thousands of rows like this: how do create new column for each attribute with the value to the business id ? and if it’s not applicable to that business id, it will specify false. example: while also noting that there are some attributes wit…

Regex Pattern in Python for special charaters

I asked a similar question a few days ago on here and it was great help! A new challenge I wanted build is to further develop the regex pattern to look for specific formats in this iteration, and I thought I have solved it using regex 101 to build/test a regex code but when applied in Python received ‘p…

Create np.array filled with zero arrays

I’m trying to initialize an “empty” array with each elements containing t_list a 8×8 np.zeros array : t_list = np.zeros((8,8), dtype=np.float32) I would now want to have a np.array with multiple t_list at each indexes: result = np.array((t_list, t_list, …., tlist)) I would like to…

Retain strings in a column using a dictionary’s value

I want to retain the string with the largest value based on a dictionary’s key and value. Any suggestion to how to do it effectively? Expected output: Answer One way it to use apply with max and fruit_dict.get as key: or, if you expect some names to be missing from the dictionary: output:

pivot df with duplicates as new rows

Evening, I have a dataframe that I want to reshape. there are duplicate id vars for some columns, and i want the duplicate values to appear as new rows my data looks like this, and i want to have the ids as a row, with the group as column, and the choices as the values. if there are multiple choices