Hi everyone,
I'm trying to find out how the IDs are evolving in my sample. In other words, I'd like to see how the IDs evolve visually (if some drop out if new people enter my sample over time, but who weren't necessarily there at the start, in which zip codes are them located, etc.).
I also want to have an overview of IDs, depending on their specific contract. In fact, after 1 June 2021, a Time-of-Use Pricing Policy came into vigour in Spain, in which all households should have the same electricity tariff type (2.0TD).
I've made a visualization with a map, but I'm not sure that it really represents all the IDs, as some may enter in 2022, others may leave, etc.). I basically drop duplicates, as the IDs could have several contracts, and then I represent the sole households in a map, using -geoplot.
I don't really know how to do that, and I'm stuck. Could someone give me some ideas for visualisation in these cases?
Thanks in advance.
I'll make an example of my data available if needed.
Have a nice day.
Thank you!
Michael
I'm trying to find out how the IDs are evolving in my sample. In other words, I'd like to see how the IDs evolve visually (if some drop out if new people enter my sample over time, but who weren't necessarily there at the start, in which zip codes are them located, etc.).
I also want to have an overview of IDs, depending on their specific contract. In fact, after 1 June 2021, a Time-of-Use Pricing Policy came into vigour in Spain, in which all households should have the same electricity tariff type (2.0TD).
I've made a visualization with a map, but I'm not sure that it really represents all the IDs, as some may enter in 2022, others may leave, etc.). I basically drop duplicates, as the IDs could have several contracts, and then I represent the sole households in a map, using -geoplot.
I don't really know how to do that, and I'm stuck. Could someone give me some ideas for visualisation in these cases?
Thanks in advance.
I'll make an example of my data available if needed.
Code:
* Example generated by -dataex-. For more info, type help dataex clear input long(id sp_zipcode) byte sp_zipcode_twodigits double(date_contract_start date_contract_end) float(kW_power_p1 kW_power_p2) str5 tariff_ekon_id 1001 9200 9 18887 21700 4.6 . "20A" 1001 9200 9 21701 22431 4.6 . "20DHA" 1001 9200 9 22432 22645 4.6 4.6 "20TD" 1001 9200 9 22646 22676 4.6 4.6 "20TD" 1001 9200 9 22677 22735 4.6 4.6 "20TD" 1001 9200 9 22736 23010 4.6 4.6 "20TD" 1001 9200 9 23011 23069 4.6 4.6 "20TD" 1001 9200 9 23070 . 4.6 4.6 "20TD" 1005 48600 48 18800 21639 3.3 . "20A" 1005 48600 48 21640 21651 3.3 . "20A" end format %td date_contract_start format %td date_contract_end
Have a nice day.
Thank you!
Michael
