split one column into two and combine in pandas

Question

I have this data in excel:

I'd like to have it read in pandas dataframe like the following:

Answer 1

You can do:

df = pd.read_excel('file.xlsx')

df = pd.DataFrame(df['V1'].values.reshape(-1,2), columns=['V1','Value'])

Output:

  V1 Value
0  A     2
1  b     4
2  c     8