I want to create a table with two columns separated by “:”. So the capitalized words as the first column and everything after the “:” as the second column. I was originally tried to do this from a PDF but that wasn’t working so I copied it to a text file thinking it might be easi…
Tag: dataframe
Transpose both columns and the first row with pandas
Please help transposing this df. Can’t think of better way doing it: df: Yellow marked are column names outcome I’m looking for: Answer try via T attribute,rename_axis(),reset_index() and melt() method: OR via T attribute,rename_axis(),stack(),reset_index() and rename() method:
Extract Value From Pandas Dataframe Based On Condition in Another Column
I am trying to develop some code that extracts the power price when a power plant starts up. To give an example refer to the following data frame. Based on this I aiming to develop some code that would store in a dataframe the power price when the plant ops columns transitions from 0 to a number greater than …
Python dataframe in one column strings delimit by comma, and in another column if pass or fail
How I can count if a country that is in more rows , has failed or passed, enter image description here Like is and the result should be like this enter image description here Because Netherlands is in 4 rows , and has 3 passed and one failed. Answer Use Series.str.split with DataFrame.explode and last call cr…
Create forth column based on other columns (lagged) values
I would like to create a forth column “D” which will take a value of 1 if: (at least) two column (A, B, C) have a value of 1 or the previous 2 periods had at least two columns with a value of 1. According to the example above all the rows would have df[‘D’]==1 Answer We can look for
Pandas dataframe get unique value of a column
I’m trying to get the unique available value for each site. The original pandas dataframe is with three columns: Site Available Capacity A 7 20 A 7 20 A 8 20 B 15 35 B 15 35 C 12 25 C 12 25 C 11 25 and I want to get the unique available of each site. The desired table
How to delete duplicates pandas
I need to check if there are some duplicates value in one column of a dataframe using Pandas and, if there is any duplicate, delete the entire row. I need to check just the first column. Example: What i need is: I can delete the ‘object’ duplicates with the following code, but I can’t delete…
pandas change dataset value of a specific row using loc
I’m new to programming, I’m working on a python project using pandas I wanted to change values of each row of a dataset using .loc, but it seems like it won’t work, the idea is to make a row take EOL value if the row is equal to 0, the code doesn’t bring an error, but my dataset is unc…
PySpark Incremental Count on Condition
Given a Spark dataframe with the following columns I am trying to construct an incremental/running count for each id based on when the contents of the event column evaluate to True. Here a new column called results would be created that contained the incremental count. I’ve tried using window functions …
Create a new column in a dataframe containing string values from different columns based on values in another column of a dataframe
I would like to add string Null at the end if conversion is 0 and add conversion column value if conversion value is 1 . `I have a below error TypeError: Cannot broadcast np.ndarray with operand of type <class ‘list’> Answer If you have dataframe like this: Then this will create new “p…