Hello!
Now I am working with many files from 2006 to 2017 (each file for each year). In every of them there are date and month of interview, cost for food in this period, year of birth of a person and so on. I need to make a column with the number of week (1, 2, 3, 4) for each month and a column with money that he/she spent on food. I have already made a column for weeks. So, for every row I defined a number from 1 to 4. I do not know how to calculate the sum of costs for a particular week and month. Eventually, I need to make a linear graph, where on X axis I will have the number of week and month, Y axis - costs.
For example,
week month costs
4 12 200
1 11 500
2 10 300
3 10 550
4 12 350
1 11 400
2 12 250
And I think that I need to get something like
week month costs
1 11 900
2 10 300
2 12 250
3 10 550
4 12 550
Later I suppose I will need to sort it in order to make a graph, but, actually, now I do not know, how to draw it, when I have two conditions on a week and a month.
Could you help me with these problems, please?
Thank you in advance
Related Posts with Summarizing essential information by some conditions
Help with StrposHi there, In the code below my goal is to convert the local below into a neat list by converting "R…
Bayesian multilevel parametric survival modelHi, I'm trying to figure out if a Bayesian multilevel parametric survival model can fit for the foll…
two-y-axeshello, I try to show my results based on two y-axes but the results are not satisfactory in the grap…
Creating a rate grouped by another variableHello, I have a large dataset (27 vars, 1,048,575 obs) that contains data on malaria insecticide t…
Testing the Equality of the Regression Coefficients After PPMLHDFEI tried to estimate a PPML gravity model of bilateral trade with country-time fixed effects by -ppml…
Subscribe to:
Post Comments (Atom)
0 Response to Summarizing essential information by some conditions
Post a Comment