Ravindra BagaleCourses & study guides

11. Reshape and Wide/Long Data

11.2 melt — Wide to Long

By Last updated: 

long = wide.melt(id_vars="city", var_name="month", value_name="gmv")
long

Steps in Jupyter

  1. Build wide.
  2. long = wide.melt(id_vars="city", var_name="month", value_name="gmv").
  3. long.sort_values(["city", "month"]).
  4. Check len(long) == 9 (3 cities × 3 months).