Hello Stata users, I have this data:
It is a data showing the load factor rate for some transport lines by months. The first variable "No Li
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str8 noligne str36 nomdelaroute str10 mois str16(nombrevoyageurs tauxremplissage) str32 montant "100" "TUNIS - NEFTA" "01/01/2022" "3?146" "104,87" "60?079,800 DT" "" "TUNIS - NEFTA" "01/02/2022" "3?196" "106,53" "60?434,160 DT" "" "TUNIS - NEFTA" "01/03/2022" "4?219" "140,63" "81?138,880 DT" "" "TUNIS - NEFTA" "01/04/2022" "3?503" "116,77" "63?575,240 DT" "" "TUNIS - NEFTA" "01/05/2022" "3?735" "124,50" "68?631,040 DT" "" "TUNIS - NEFTA" "01/06/2022" "3?486" "116,20" "65?899,990 DT" "" "TUNIS - NEFTA" "01/07/2022" "3?906" "130,20" "77?700,910 DT" "" "TUNIS - NEFTA" "01/08/2022" "3?915" "130,50" "77?533,070 DT" "" "TUNIS - NEFTA" "01/09/2022" "3?617" "120,57" "68?388,840 DT" "" "TUNIS - NEFTA" "01/10/2022" "3?673" "122,43" "64?401,430 DT" "" "TUNIS - NEFTA" "01/11/2022" "3?305" "110,17" "59?830,040 DT" "" "TUNIS - NEFTA" "01/12/2022" "4?004" "133,47" "76?078,540 DT" "" "Distance Moyenne par Voyageur en KLM" "" "349 KM" "121,40" "Montant par voyageur 18,847 DT" "" "" "" "" "" "" "No Ligne" "Nom de la route" "Mois" "Nombre Voyageurs" "Taux Remplissage" "Montant" "101" "TUNIS - GAFSA" "01/01/2022" "2?092" "69,73" "38?386,880 DT" "" "TUNIS - GAFSA" "01/02/2022" "2?309" "76,97" "44?703,690 DT" "" "TUNIS - GAFSA" "01/03/2022" "3?554" "118,47" "71?140,490 DT" "" "TUNIS - GAFSA" "01/04/2022" "3?344" "111,47" "69?251,680 DT" "" "TUNIS - GAFSA" "01/05/2022" "3?292" "109,73" "64?036,580 DT" "" "TUNIS - GAFSA" "01/06/2022" "3?358" "111,93" "65?082,640 DT" "" "TUNIS - GAFSA" "01/07/2022" "3?916" "130,53" "77?911,300 DT" "" "TUNIS - GAFSA" "01/08/2022" "3?772" "125,73" "76?316,920 DT" "" "TUNIS - GAFSA" "01/09/2022" "3?453" "115,10" "68?124,460 DT" "" "TUNIS - GAFSA" "01/10/2022" "3?432" "114,40" "64?847,450 DT" "" "TUNIS - GAFSA" "01/11/2022" "3?176" "105,87" "61?342,060 DT" "" "TUNIS - GAFSA" "01/12/2022" "3?608" "120,27" "72?597,690 DT" "" "Distance Moyenne par Voyageur en KLM" "" "365 KM" "109,18" "Montant par voyageur 19,685 DT" "" "" "" "" "" "" "No Ligne" "Nom de la route" "Mois" "Nombre Voyageurs" "Taux Remplissage" "Montant" "102" "TUNIS - NEFTA" "01/01/2022" "3?895" "129,83" "69?131,340 DT" "" "TUNIS - NEFTA" "01/02/2022" "3?900" "130,00" "65?870,060 DT" "" "TUNIS - NEFTA" "01/03/2022" "5?068" "168,93" "93?833,690 DT" "" "TUNIS - NEFTA" "01/04/2022" "3?667" "122,23" "64?247,960 DT" "" "TUNIS - NEFTA" "01/05/2022" "3?987" "132,90" "70?179,530 DT" "" "TUNIS - NEFTA" "01/06/2022" "4?006" "133,53" "68?306,020 DT" "" "TUNIS - NEFTA" "01/07/2022" "4?265" "142,17" "84?611,010 DT" "" "TUNIS - NEFTA" "01/08/2022" "4?733" "157,77" "90?205,400 DT" "" "TUNIS - NEFTA" "01/09/2022" "4?408" "146,93" "77?030,210 DT" "" "TUNIS - NEFTA" "01/10/2022" "4?657" "155,23" "79?019,990 DT" "" "TUNIS - NEFTA" "01/11/2022" "4?300" "143,33" "72?577,600 DT" "" "TUNIS - NEFTA" "01/12/2022" "4?688" "156,27" "79?962,220 DT" "" "Distance Moyenne par Voyageur en KLM" "" "329 KM" "143,26" "Montant par voyageur 17,741 DT" "" "" "" "" "" "" "No Ligne" "Nom de la route" "Mois" "Nombre Voyageurs" "Taux Remplissage" "Montant" "103" "SOUSSE - MIDOUNE" "01/01/2022" "4" "0,13" "31,200 DT" "" "SOUSSE - MIDOUNE" "01/02/2022" "8" "0,27" "0,000 DT" "" "SOUSSE - MIDOUNE" "01/03/2022" "68" "2,27" "1?048,080 DT" "" "SOUSSE - MIDOUNE" "01/04/2022" "4" "0,13" "38,000 DT" "" "SOUSSE - MIDOUNE" "01/05/2022" "5" "0,17" "5,700 DT" "" "SOUSSE - MIDOUNE" "01/06/2022" "2" "0,07" "3,000 DT" "" "SOUSSE - MIDOUNE" "01/07/2022" "5" "0,17" "0,000 DT" "" "SOUSSE - MIDOUNE" "01/08/2022" "8" "0,27" "43,400 DT" "" "SOUSSE - MIDOUNE" "01/09/2022" "3" "0,10" "33,850 DT" "" "SOUSSE - MIDOUNE" "01/10/2022" "10" "0,33" "10,450 DT" "" "SOUSSE - MIDOUNE" "01/11/2022" "3" "0,10" "25,950 DT" "" "SOUSSE - MIDOUNE" "01/12/2022" "229" "7,63" "4?257,680 DT" "" "Distance Moyenne par Voyageur en KLM" "" "292 KM" "0,97" "Montant par voyageur 15,752 DT" "" "" "" "" "" "" "No Ligne" "Nom de la route" "Mois" "Nombre Voyageurs" "Taux Remplissage" "Montant" "104" "TUNIS - B. GUARDEN" "01/01/2022" "2?220" "74,00" "52?224,490 DT" "" "TUNIS - B. GUARDEN" "01/02/2022" "1?916" "63,87" "45?628,910 DT" "" "TUNIS - B. GUARDEN" "01/03/2022" "3?043" "101,43" "69?857,490 DT" "" "TUNIS - B. GUARDEN" "01/04/2022" "1?981" "66,03" "45?996,400 DT" "" "TUNIS - B. GUARDEN" "01/05/2022" "2?376" "79,20" "54?205,280 DT" "" "TUNIS - B. GUARDEN" "01/06/2022" "2?394" "79,80" "53?450,810 DT" "" "TUNIS - B. GUARDEN" "01/07/2022" "3?001" "100,03" "71?013,880 DT" "" "TUNIS - B. GUARDEN" "01/08/2022" "2?810" "93,67" "63?737,840 DT" "" "TUNIS - B. GUARDEN" "01/09/2022" "2?911" "97,03" "65?862,820 DT" "" "TUNIS - B. GUARDEN" "01/10/2022" "2?329" "77,63" "46?320,610 DT" "" "TUNIS - B. GUARDEN" "01/11/2022" "1?515" "50,50" "32?298,440 DT" "" "TUNIS - B. GUARDEN" "01/12/2022" "2?615" "87,17" "56?153,820 DT" "" "Distance Moyenne par Voyageur en KLM" "" "418 KM" "80,86" "Montant par voyageur 22,560 DT" "" "" "" "" "" "" "No Ligne" "Nom de la route" "Mois" "Nombre Voyageurs" "Taux Remplissage" "Montant" "105" "TUNIS - SIDI BOUZID" "01/01/2022" "2?419" "80,63" "33?297,170 DT" "" "TUNIS - SIDI BOUZID" "01/02/2022" "2?459" "81,97" "32?326,360 DT" "" "TUNIS - SIDI BOUZID" "01/03/2022" "3?452" "115,07" "47?231,740 DT" "" "TUNIS - SIDI BOUZID" "01/04/2022" "2?880" "96,00" "39?075,860 DT" "" "TUNIS - SIDI BOUZID" "01/05/2022" "3?012" "100,40" "41?803,150 DT" "" "TUNIS - SIDI BOUZID" "01/06/2022" "3?236" "107,87" "45?484,370 DT" "" "TUNIS - SIDI BOUZID" "01/07/2022" "3?361" "112,03" "50?074,340 DT" "" "TUNIS - SIDI BOUZID" "01/08/2022" "3?941" "131,37" "54?750,280 DT" "" "TUNIS - SIDI BOUZID" "01/09/2022" "3?226" "107,53" "44?775,840 DT" "" "TUNIS - SIDI BOUZID" "01/10/2022" "3?256" "108,53" "44?024,840 DT" "" "TUNIS - SIDI BOUZID" "01/11/2022" "2?967" "98,90" "39?092,290 DT" "" "TUNIS - SIDI BOUZID" "01/12/2022" "3?488" "116,27" "48?116,930 DT" "" "Distance Moyenne par Voyageur en KLM" "" "255 KM" "104,71" "Montant par voyageur 13,796 DT" "" "" "" "" "" "" "No Ligne" "Nom de la route" "Mois" "Nombre Voyageurs" "Taux Remplissage" "Montant" "106" "TUNIS - TAMEGHZA" "01/01/2022" "191" "6,37" "3?576,440 DT" "" "TUNIS - TAMEGHZA" "01/02/2022" "5" "0,17" "49,100 DT" "" "TUNIS - TAMEGHZA" "01/03/2022" "175" "5,83" "3?229,920 DT" "" "TUNIS - TAMEGHZA" "01/04/2022" "13" "0,43" "222,000 DT" "" "TUNIS - TAMEGHZA" "01/05/2022" "325" "10,83" "6?045,800 DT" "" "TUNIS - TAMEGHZA" "01/06/2022" "3" "0,10" "40,000 DT" "" "TUNIS - TAMEGHZA" "01/07/2022" "433" "14,43" "8?035,670 DT" "" "TUNIS - TAMEGHZA" "01/08/2022" "4" "0,13" "36,500 DT" "" "TUNIS - TAMEGHZA" "01/09/2022" "1" "0,03" "7,100 DT" "" "TUNIS - TAMEGHZA" "01/10/2022" "3" "0,10" "28,800 DT" end
Comment