I have a dataframe that looks like the following:

with values inside the table filled out. I would like to pivot the data from wide to long. the desired output looks as follows:

I have more than 100 dates which I have stored in a dataframe or a list called mydates I have used the following code:

df_long= pd.wide_to_long(df_wide, stubnames = ['xx','yyy','z'], i='id', j = mydates, sep='_', suffix=r'\w ')

but it gives me errors: "too many levels: Index has only 1 level, not 2" or "Must pass DataFrame or 2-d ndarray with boolean values only"

what am I doing wrong?

CodePudding user response：

Try this:

pd.wide_to_long(
    df, stubnames=["xx", "yyy", "z"], i="id", j="date", sep="_", suffix=r".*"
)