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…
Tag: dataframe
Break line chart on the plot
I have a dataframe with a column for weeks and data captured for each week. it looks like this Now I am plotting a line chart with this data . Notice that from week 23 to week 40, we didnt have data. so my intention is to skip this weeks on the plot and only have a line chart of
Pandas: filter on grouped and aggregated dataframe
I have a dataframe which is based on a read-in excel list. The data has multiple columns and rows with one unique identifier. I want to plot the data through a PyQT interface based on some user selection (checkboxes), but I cannot select one unique row for plotting. The data looks like this: After I get this:…
(python) subtract value in a list from value in the same list in a for loop / list comprehension
suppose i have in a for loop I want to subtract the value i from the value that comes right after. In the above example: 4-3, 6-4, 8-6, 13-8. (and i want to skip the first value) desired result can i do this in a for loop / list comprehension? more specifically do I want to do this in a
Find the median of a column based on criteria within dataframe and insert this as a new column
I’m trying to look in a dataframe, and find the median of data within a column based on another column. I have a dataframe with ‘zipcode’ data and ‘price’ data. I want to find the median of the ‘price’ based on the ‘zipcode’, and report it in a new column.…
pandas – creating new rows of combination with value of 0
I have a pandas dataframe like user_id music_id has_rating A a 1 B b 1 and I would like to automatically add new rows for each of user_id & music_id for those users haven’t rated, like user_id music_id has_rating A a 1 A b 0 B a 0 B b 1 for each of user_id and music_id combination pairs those
Combining multiple CSVs in pandas
I have multiple csv files (which I’ve moved into pandas dataframes) in a folder, each of which holds monthly website data and need to combine them by copying the Value column from each to make a new dataframe (which will ultimately be exported to another csv) A new csv file will be added to the folder e…
Name ‘ ‘ is not defined – python
from bunch of files I want to extract some info (code is below), but I came across error: “name ‘GH_Pos21X_true’ is not defined”, full error: Where should I defined it? Code: I can’t see a problem, maybe someone could help me find my mistake? I will be grateful. If I don’t …
Map the multiple value dictionary with a dataframe column
I have a dictionary with multiple values for 1 key. Now, I need to map them with the dataframe column. Any idea how can I solve this? Dictionary Data Expected Answer First we convert the Keys_nd_Values to a df and convert the rows to columns. The function we wrote later does this: get the value of the column …
How to append dataframe to an existing excel file with some rows of data in it?
I have an excel sheet which has 150 rows of data. Now, I want to append a dataframe to that sheet without deleting or replacing the data using python. I have tried code like this, it is deleting the existing content from the excel and writing the dataframe into it. And other solutions provided here but with n…