#Column X contains the suffix of one of V* columns. Need to put set column V{X} to 9 if X > 1. #But my code created a new column ‘VX’ instead of updating one of the V* columns import pandas as pd df = pd.DataFrame({‘EMPLID’: [12, 13, 14, 15, 16, 17, 18], ‘V1’: [2,3,4,50,6,7,8], ‘V2’: […]

below is my dataframe code

below is my dataframe code

I’m wondering how to use the capitalize function when another column has a specific value.
For example, I want to change the first letter of students with Master’s degree.

I have multiple A* columns with corresponding B* columns (A and B have the corresponding numbers at the end of the column names).
When the REFNO value = A# value and the ‘MNGR’ is not BOB,
I need to put the value from corresponding B# column into the ‘AGE’ column and the corresponding # number in the ‘FLAG’ column

I am trying to read excel which is formulated means some values in excel is driven from formula I have tried two approach but I don’t receive any value. I get ‘None’. Can someone of you review my code and help me please?

I have an example dataframe:

enter image description hereI have the following dataframe as shown in the figure. I want to set the value of Column B based on the value in the column name that corresponds to Column A value. For example, Column A first row reads “Value A”, so look for Value A column and find “aaa”. Any hint on how to do this? Thank you

I have a data frame with 3 columns:

Hi there I have read a csv file using pd.read_csv()