Column names are: ID,1,2,3,4,5,6,7,8,9. The col values are either 0 or 1 My dataframe looks like this: I want the column names in front of the ID where the value in a row is 1. The Dataframe i want should look like this: Please help me in this, Thanks in advance Answer set_index + stack, stack will dropna by …
Tag: python
Creating a nested dictionary from a flattened dictionary
I have a flattened dictionary which I want to make into a nested one, of the form I want to convert it to the form The structure of the flat dictionary is such that there should not be any problems with ambiguities. I want it to work for dictionaries of arbitrary depth, but performance is not really an issue.…
How to plot aggregated by date pandas dataframe
I have this dataframe To aggregate payout_value by date I use: How do I plot (bar chart) dates on x-axis and aggregated payout sum on y axis? I tried using df.plot(x=’date’, y=’payout_value’,kind=”bar”) approach, but there is no ‘date’ column in df_daily datafra…
What does a backslash mean in a string literal?
I made a list of strings like this: But if I try to print it, I get a very different looking result: Why does this happen? Does the character have some special meaning here? Answer The backslash is used to escape special (unprintable) characters in string literals. n is for newline, t for tab, f for a form-f…
convert dataframe row to dict
I have datarame like the sample data below. I’m trying to convert one row from the dataframe in to a dict like the desired output below. But when I use to_dict I get the indice along with the column value. Does anyone know how to get convert the row to a dict like the desired output? Any tips greatly ap…
Extract coefficients and corresponding monomials from a given polynomial in SymPy
Given a symbolic multivariate polynomial P, I need to extract both its coefficients and corresponding monomials as lists: such that P is the dot product of coefficients and monomials, e.g., if P(x,y) = ax**2 + bxy + cy**2 then we should get coeffs = [a, b, c] and monoms = [x**2, x*y, y**2]. Getting the coeffi…
Python scraping website shows unknown url type: view-source
I am trying to do scraping in Python. Then, I want to scrape a stock-info website. But I failed, I don’t know why. It gives the error below: But when I used Chrome I can view the source code by right-click. Answer Try removing view-source: from your url_src, in essence: I think view-source: is Chrome sp…
Authentication plugin ‘caching_sha2_password’ is not supported
I am trying to connect to a MySQL server with python connector. I created a new user lcherukuri with the authentication plugin mysql_native_password. But I got the error mysql.connector.errors.NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported Can someone help me? An…
Inserting rows in QTreeView that uses QSortFilterProxyModel
I have a very basic app that displays a tree view and a button that adds items to that tree view, using current selection as a parent. Inserting a first level child works well while inserting the 3d level child fails for some reason (it just is not displayed after inserting is done. I’ve prepared fully …
Calling super().__init__(**kwargs), and multiple inheritance?
I’m trying to learn and understand how to use super in Python, Ive been following the book ‘Python journey from novice to expert’ and although I feel that I understand the concept Im having problems executing super in my own code. For example, this method works for me: returns the following:…