Hello
I have this data. I want to create a one-graph or two-way graph to compare my data in a specific time period. I have data about the percentage of lockdowns during COVID-19 in industries. I would like to get a graph showing the percentage of lockdowns in all industries in three time periods ( We have three time lockdown periods):
First: from Jan - Mar 2020 week 11 TO April - June 2020 week 7
Second: from July - Sep 2020 week 3 TO July - Sep 2020 week 8
Third: from Oct - Des 2020 week 5 TO Oct - Des 2020 week 9
can I get a graph showing all three time periods in all industries with clearly separate the time in the graph? or could I just compare three time periods in one industry in one graph ? how can I do it in Stata?
I really appreciate to advice me the best wat to visualise my data to get more sense
Many thanks in advance
I have this data. I want to create a one-graph or two-way graph to compare my data in a specific time period. I have data about the percentage of lockdowns during COVID-19 in industries. I would like to get a graph showing the percentage of lockdowns in all industries in three time periods ( We have three time lockdown periods):
First: from Jan - Mar 2020 week 11 TO April - June 2020 week 7
Second: from July - Sep 2020 week 3 TO July - Sep 2020 week 8
Third: from Oct - Des 2020 week 5 TO Oct - Des 2020 week 9
can I get a graph showing all three time periods in all industries with clearly separate the time in the graph? or could I just compare three time periods in one industry in one graph ? how can I do it in Stata?
I really appreciate to advice me the best wat to visualise my data to get more sense
Code:
* Example generated by -dataex-. For more info, type help dataex clear input byte quarter float wdate str68 industry double lockdwon 7 80 "Education" 0 4 43 "Human Health And Social Work Activities" 0 8 101 "Electricity, gas, air cond supply" 0 5 53 "Manufacturing" 0 6 72 "Human Health And Social Work Activities" 0 4 50 "Manufacturing" 0 7 84 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 5 53 "Human Health And Social Work Activities" 0 5 54 "Professional, Scientific And Technical Activities" 0 7 86 "Other service activities" 0 4 41 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 11 132 "Education" 0 4 48 "Human Health And Social Work Activities" 0 5 65 "Manufacturing" 22.7 8 100 "Education" 0 7 86 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 8 101 "Manufacturing" 6.3 7 79 "Construction" 4.1 6 73 "Public admin and defence" 0 7 89 "Extraterritorial organisations" 0 7 83 "Transportation And Storage" 2.2 12 146 "Administrative And Support Service Activities" 0 8 95 "Manufacturing" 8.3 4 43 "Manufacturing" 0 6 69 "Accommodation And Food Service Activities" 78.1 8 104 "Education" 0 7 90 "Other service activities" 0 7 83 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 1.8 7 83 "Education" 3.5 9 111 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 29.4 5 61 "Human Health And Social Work Activities" 0 9 111 "Construction" 17.4 7 86 "Construction" 0 6 74 "Manufacturing" 0 4 50 "Human Health And Social Work Activities" 0 4 47 "Public admin and defence" 0 8 98 "Administrative And Support Service Activities" 0 12 150 "Construction" 0 9 114 "Human Health And Social Work Activities" 0 6 78 "Education" 0 7 83 "Construction" 2.4 7 90 "Administrative And Support Service Activities" 0 7 88 "Public admin and defence" 0 4 40 "Professional, Scientific And Technical Activities" 0 10 123 "Accommodation And Food Service Activities" 37.9 8 92 "Human Health And Social Work Activities" 0 7 85 "Manufacturing" 0 5 56 "Human Health And Social Work Activities" 0 5 58 "Education" 0 7 87 "Public admin and defence" 0 5 57 "Education" 0 5 58 "Manufacturing" 0 11 131 "Other service activities" 0 12 147 "Manufacturing" 3.3 7 90 "Professional, Scientific And Technical Activities" 0 4 52 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 6 78 "Manufacturing" 0 4 42 "Financial and insurance activities" 0 9 117 "Education" 34.8 6 75 "Professional, Scientific And Technical Activities" 7.5 7 86 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 6 74 "Human Health And Social Work Activities" 0 7 80 "Human Health And Social Work Activities" 0 5 61 "Information And Communication" 0 11 134 "Human Health And Social Work Activities" 0 9 112 "Human Health And Social Work Activities" 0 7 80 "Construction" 0 8 95 "Arts, Entertainment And Recreation" 24.2 6 78 "Human Health And Social Work Activities" 0 11 135 "Arts, Entertainment And Recreation" 6.6 4 46 "Professional, Scientific And Technical Activities" 0 4 41 "Education" 0 8 100 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 7 86 "Human Health And Social Work Activities" 0 7 80 "Information And Communication" 0 5 56 "Education" 0 5 58 "Information And Communication" 0 7 82 "Manufacturing" 0 8 96 "Education" 0 7 88 "Construction" 0 12 144 "Wholesale And Retail Trade; Repair Of Motor Vehicles And Motorcycles" 0 4 41 "Professional, Scientific And Technical Activities" 0 5 57 "Public admin and defence" 0 7 86 "Professional, Scientific And Technical Activities" 0 10 128 "Information And Communication" 0 12 146 "Public admin and defence" 0 7 83 "Construction" 2.4 9 108 "Human Health And Social Work Activities" 0 8 102 "Education" 0 5 56 "Manufacturing" 0 8 100 "Other service activities" 0 7 83 "Manufacturing" 0 5 62 "Other service activities" 0 9 113 "Information And Communication" 15 9 112 "Professional, Scientific And Technical Activities" 0 7 88 "Manufacturing" 0 5 55 "Transportation And Storage" 0 9 108 "Manufacturing" 0 6 78 "Education" 0 9 113 "Human Health And Social Work Activities" 19.9 end label values quarter quarter label def quarter 4 "Oct-Des 2019", modify label def quarter 5 "Jan-Mar 2020", modify label def quarter 6 "Apr-June 2020", modify label def quarter 7 "July-Sep 2020", modify label def quarter 8 "Oct-Des 2020", modify label def quarter 9 "Jan-Mar 2021", modify label def quarter 10 "Apr-June 2021", modify label def quarter 11 "July-Sep 2021", modify label def quarter 12 "Oct-Des 2021", modify label values wdate wdate label def wdate 40 "Oct-Des 2019 1", modify label def wdate 41 "Oct-Des 2019 2", modify label def wdate 42 "Oct-Des 2019 3", modify label def wdate 43 "Oct-Des 2019 4", modify label def wdate 46 "Oct-Des 2019 7", modify label def wdate 47 "Oct-Des 2019 8", modify label def wdate 48 "Oct-Des 2019 9", modify label def wdate 50 "Oct-Des 2019 11", modify label def wdate 52 "Oct-Des 2019 13", modify label def wdate 53 "Jan-Mar 2020 1", modify label def wdate 54 "Jan-Mar 2020 2", modify label def wdate 55 "Jan-Mar 2020 3", modify label def wdate 56 "Jan-Mar 2020 4", modify label def wdate 57 "Jan-Mar 2020 5", modify label def wdate 58 "Jan-Mar 2020 6", modify label def wdate 61 "Jan-Mar 2020 9", modify label def wdate 62 "Jan-Mar 2020 10", modify label def wdate 65 "Jan-Mar 2020 13", modify label def wdate 69 "Apr-June 2020 4", modify label def wdate 72 "Apr-June 2020 7", modify label def wdate 73 "Apr-June 2020 8", modify label def wdate 74 "Apr-June 2020 9", modify label def wdate 75 "Apr-June 2020 10", modify label def wdate 78 "Apr-June 2020 13", modify label def wdate 79 "July-Sep 2020 1", modify label def wdate 80 "July-Sep 2020 2", modify label def wdate 82 "July-Sep 2020 4", modify label def wdate 83 "July-Sep 2020 5", modify label def wdate 84 "July-Sep 2020 6", modify label def wdate 85 "July-Sep 2020 7", modify label def wdate 86 "July-Sep 2020 8", modify label def wdate 87 "July-Sep 2020 9", modify label def wdate 88 "July-Sep 2020 10", modify label def wdate 89 "July-Sep 2020 11", modify label def wdate 90 "July-Sep 2020 12", modify label def wdate 92 "Oct-Des 2020 1", modify label def wdate 95 "Oct-Des 2020 4", modify label def wdate 96 "Oct-Des 2020 5", modify label def wdate 98 "Oct-Des 2020 7", modify label def wdate 100 "Oct-Des 2020 9", modify label def wdate 101 "Oct-Des 2020 10", modify label def wdate 102 "Oct-Des 2020 11", modify label def wdate 104 "Oct-Des 2020 13", modify label def wdate 108 "Jan-Mar 2021 4", modify label def wdate 111 "Jan-Mar 2021 7", modify label def wdate 112 "Jan-Mar 2021 8", modify label def wdate 113 "Jan-Mar 2021 9", modify label def wdate 114 "Jan-Mar 2021 10", modify label def wdate 117 "Jan-Mar 2021 13", modify label def wdate 123 "Apr-June 2021 6", modify label def wdate 128 "Apr-June 2021 11", modify label def wdate 131 "July-Sep 2021 1", modify label def wdate 132 "July-Sep 2021 2", modify label def wdate 134 "July-Sep 2021 4", modify label def wdate 135 "July-Sep 2021 5", modify label def wdate 144 "Oct-Des 2021 1", modify label def wdate 146 "Oct-Des 2021 3", modify label def wdate 147 "Oct-Des 2021 4", modify label def wdate 150 "Oct-Des 2021 7", modify
Many thanks in advance
Comment