Say I have a dataframe with 2 columns, how would I create all possible combinations for a specific combination size? Each row of the df should be treated as 1 item in the combination rather than 2 unique separate items. I want the columns of the combinations to be appended to the right.

I would like to plot each polygon’s number within the polygon (not usually done). I am able to write the polygon names to a csv file with the following code;

I can drop entire row/column using drop(), how to drop a single cell and shifting the next value up without dropping the entire row. Is there any in-built function for this?

I have the following pandas dataframe:

UserWarning: Pandas doesn’t allow columns to be created via a new attribute name – see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access

Example

If I have a df like this one:

How can I merge these two dataframes?

I have an example imported excel spreadsheet that appears like this with many more entries and i read in with pd.read_excel. I would like to delete all of ID 3’s entries since the status is deleted and I would like to remove the whole index 7 since the region is not set. I started off by setting a mulit index with df = df.set_index(['id']), I then performed this df.set_index('id')[['status']].eq('deleted').groupby(level=0).all()
and got the True/False value results with an extra false in the row above the first entry. Unsure how to perform the delete row if region mission.

I have an example imported excel spreadsheet that appears like this with many more entries and i read in with pd.read_excel. I would like to delete all of ID 3’s entries since the status is deleted and I would like to remove the whole index 7 since the region is not set. I started off by setting a mulit index with df = df.set_index(['id']), I then performed this df.set_index('id')[['status']].eq('deleted').groupby(level=0).all()
and got the True/False value results with an extra false in the row above the first entry. Unsure how to perform the delete row if region mission.