I keep getting the error and can’t find where the problem lies. I’m trying so I can choose wether I want the attack the creature or both printed and what type the creature is: ‘easy’, ‘medium’ or ‘hard’, I want to store that into a variable. Thanks in advance An…
Tag: dictionary
Extract a value from a JSON string stored in a pandas data frame column
I have a pandas dataframe with a column named json2 which contains a json string coming from an API call: “{‘obj’: [{‘timestp’: ‘2022-12-03’, ‘followers’: 281475, ‘avg_likes_per_post’: 7557, ‘avg_comments_per_post’: 182, ‘avg_…
How do I fill a dictionary with indices in a for loop?
I have a transposed Dataframe tr: 7128 8719 14051 14636 JDUTC_0 2451957.36 2452149.36 2457243.98 2452531.89 JDUTC_1 2451957.37 2452149.36 2457243.99 2452531.90 JDUTC_2 2451957.37 2452149.36 2457244.00 2452531.91 JDUTC_3 NaN 2452149.36 NaN NaN JDUTC_4 NaN 2452149.36 NaN NaN JDUTC_5 NaN 2452149.36 NaN NaN JDUTC…
How to convert a 5-level dictionary into a DataFrame?
I have a dictionary with structure: Level 1: id (int) username (str) meta (contain a string of Kpi_info) This is a dictionary: My desire result is a DataFame like this: id username Year Month revenue kpi result 206 hantran 2021 1 2000 2100 0 206 hantran 2021 2 2500 2000 1 206 hantran 2022 1 3000 2500 1 206 ha…
how to divide a column element wise in python
I want to divide the first column of this table element wise by 3.6. enter image description here It throws an error something like : Here’s what I tried: Answer There are several ways to do it, here are two. I suggest from your error message that your data is in a pd.DataFrame. I used a shortened versi…
How to convert nested dictionary to levelled Pandas Dataframe
How to convert more than 3 level N nested dictionary to levelled dataframe? what I expect: index level_0 level_1 value 0 .Stock .No_0 3241512 1 .Stock .No_1 1111111111 2 .Stock .No_2 444444444444 3 .Stock .Version 46 4 .Stock .Revision 78 5 .Time NaN 12.11.2022 Firsly I need to convert nested dictionary to li…
python nested dictionaries from sql queries
Hello i am trying to create a dictionary that would like this I have the following in a db which i am querying i have the following code in order to loop through the query results and create a dictionary but its not creating it like the i am wanting it o Any help would be very much appreciated. Answer
How do I print a dictionary’s keys based on its value?
So, I’ve created a dictionary of key, value pairs for course name and student ID respectively. I want to be able to iterate through the dictionary and print all of the keys (course names) that contain a particular value (student ID). So, here’s the first initialization of variables followed by ask…
Print the duplicate values from a dictionary in Python
I just wonder if it’s possible to print the duplicate values from a dictionary. For exemple I have this dictonary: So if I pick two different keys like: They have a common coffee name like: Purity Coffee Flow, Out Of The Grey Costa Rica La Minita So if I insert the keys for it like: chocolate, medium. T…
Updating A List Word Counter
I’m creating a program that counts letters. I created two dictionaries that both have the same word and, because they are the same exact word, both have the same counter. I want to know how to merge the two dictionaries so that it updates the counters as well, but I consistently receive the result ̶…