This is my data frame:
Location Category Value
0 1 A 1.130
1 1 B 2.550
2 2 A 1.130
3 2 B 3.982
4 2 C 1.580
5 3 C 5.070
As you can see, all Location
(1 / 2 / 3) do not display all Category
(A / B / C). I would like to restructure this data frame so that each Location
is now associated with each Category
, by putting 0 in the new Value
cells; this should lead to the following data frame:
Location Category Value
0 1 A 1.130
1 1 B 2.550
2 1 C 0.000
3 2 A 1.130
4 2 B 3.982
5 2 C 1.580
6 3 A 0.000
7 3 B 0.000
8 3 C 5.070
I know some posts seem to deal with this question, for example Pandas Merging 101, but I did not find how to apply the procedures indicated to my particular case...
I also know that I could manually create the data frame I want, but my original data frame is more complicated than the example given, that's why I'm looking for a pythonic coded way to achieve what I want.
Any idea welcome.
Appendix - create the data frame given as example:
import pandas as pd
Location = [1, 1, 2, 2, 2, 3]
Category = ['A', 'B', 'A', 'B', 'C', 'C']
Value = [1.13, 2.55, 1.13, 3.982, 1.58, 5.07]
df = pd.DataFrame({'Location':Location, 'Category':Category, 'Value':Value})
df