How do I return the column title of a cell, combine it with another value and store it in a new dataframe?

Question

I have a dataframe with which if a cell has a value other than "." then I need python to return the cell's column title and the campus number. The end result should be a new dataframe or list that contains the column title and the campus number. It does not matter what the value inside the cell is, as long as it is not "." I tried to use the following for loop statement: df is the original dataframe df2 is the new dataframe that is supposed to have column name and campus name for i in df.iterrows(): if df[i] == ".": i = i + 1 else: df2[i] = df[i].value + "" + df.col() i = i + 1 JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Reducing the dimensionality of the problem by stacking makes it easier as you can then simply query the index. temp = df.set_index('Campus').stack() result_list = temp.loc[temp!='.'].index.values