Comparative analysis of the traffic accidents in the territory of the city of Užice for 2021 and 2022 using open data and the Streamlit application

Keywords: Descriptive analytics, open data, Streamlit, Pandas, Python, traffic accidents

Abstract


Introduction/purpose: With the development of information technologies, the Internet and social networks, the amount of collected data grows year by year at high speed. Data processing and analysis is becoming a necessity without which quality business decisions cannot be made. With the development of data science, tools for processing unstructured data have also been developed. Open data is publicly available data, the processing of which allows gaining new knowledge. The goal of the work is to present the possibility of using open data for research purposes, and their processing through the Streamlit development environment.

Methods: This paper will present the Streamlit framework of the Python programming language and its functionality through the analysis of a web application for data analytics. As a case study, a comparative analysis of the traffic accident data on the territory of the Užice Police Department for 2021 and 2022 will be presented.

Results: The Streamlit application will be used for the automatic analysis of open data on the traffic accidents in the territory of the Republic of Serbia in order to process the data and test the hypothesis about whether there has been an increase in traffic safety in the territory of the Užice Police Department.

Conclusion: This work shows the possibility of using the Streamlit framework for creating an application for processing open data.

 

References

Ayre, L.B. & Craner, J. 2017. Open Data: What It Is and Why You Should Care. Public Library Quarterly, 36(2), pp.173-184. Available at: https://doi.org/10.1080/01616846.2017.1313045.

Daley, S. 2022. Data Science What is Data Science? А Complete Guide. Builtin.com, 17 August [online]. Available at: https://builtin.com/data-science [Accessed: 10 March 2023].

-Data.gov.rs (Portal otvorenih podataka Vlade Republike Srbije). 2023a. Otvoreni podaci [online]. Available at: https://data.gov.rs/sr/discover/ (in Serbian) [Accessed: 10 March 2023].

 -Data.gov.rs (Portal otvorenih podataka Vlade Republike Srbije). 2023b. Podaci o saobraćajnim nezgodama po POLICIJSKIM UPRAVAMA i OPŠTINAMA [online]. Available at: https://data.gov.rs/sr/datasets/podatsi-o-saobratshajnim-nezgodama-po-politsijskim-upravama-i-opshtinama/ (in Serbian) [Accessed: 10 March 2023].

-Docs.streamlit.io. 2023. Streamlit documentation [online]. Available at: https://docs.streamlit.io/ [Accessed: 10 March 2023].

Dymora, P., Mazurek, M. & Kowal, B. 2018. Open data – an introduction to the issue. In: ITM Web of Conferences 21, 00017 (2018). Available at: https://doi.org/10.1051/itmconf/20182100017.

Gavrilović, B. 2023. Aplikacija za automatsku obradu otvorenih podataka o saobraćajnim nesrećama [online]. Available at: https://brankogavrilovic-automatska-obrada-homepage-r3ltns.streamlit.app/ (in Serbian) [Accessed: 03. March 2023].

Gladović, P.V. & Deretić, N.N. 2018. Open data and databases in analysis of traffic accidents in Belgrade. Tehnika, 73(2), pp.247-253 (in Serbian). Available at: https://doi.org/10.5937/tehnika1802247G.

-Global Open Data Index. 2023. Place overview [online]. Available at: https://index.okfn.org/place.html [Accessed: 10 March 2023].

Keserű, J. & Kin-Sing Chan, J. 2015. The Social Impact of Open Data. In: 3rd International Open Data Conference (IODC), Ottawa, Canada, May 28-29.

Khorasani, M., Abdou, M. & Hernández Fernández, J. 2022. Streamlit Basics. In: Web Application Development with Streamlit. Berkeley, CA: Apress. Available at: https://doi.org/10.1007/978-1-4842-8111-6_2.

Konova, P.S. 2022. Streamlit library as a tool for processing and visualization of big data. Stolypin messenger, 3(2) [online]. Available at: https://stolypin-vestnik.ru/wp-content/uploads/2022/08/59.pdf (in Russian) [Accessed: 10 March 2023]. (In the original: Конова, П.С. 2022. Библиотека streamlit как инструмент обработки и визуализации больших данных. Столыпинский вестник, 3(2) [онлайн]. Доступно на: https://stolypin-vestnik.ru/wp-content/uploads/2022/08/59.pdf (in Russian) [Дата обращения: 10 Март 2023].)

Krivokapić, Đ., Adamović, J., Milošević, F. & Kosmina, K. 2019. Vodič kroz otvorene podatke. Belgrade: United Nations Development Programme [online]. Available at: https://data.gov.rs/_themes/govrs/doc/vodic-kroz-otvorene-podatke_cirilica.pdf (in Serbian) [Accessed: 10 March 2023]. ISBN: 978-86-7728-259-2.

-Opservatorija društvenih inovacija. 2023. O vizuelizaciji: gde se dešavaju saobraćajne nezgode [online]. Available at: https://data.odi.rs/rsnezgode/ (in Serbian) [Accessed: 10 March 2023].

-Pandas.pydata.org. 2023. Pandas documentation [online]. Available at: https://pandas.pydata.org/docs/ [Accessed: 10 March 2023].

-Reddit.com. 2020. Stack overflow traffic to questions about selected python packages [online]. Avaiable at: https://www.reddit.com/r/Python/comments/jogwc5/stack_overflow_traffic_to_questions_about/ [Accessed: 10 March 2023].

Saxena, A. & Robila, S.A. 2021. Analysis of the New York City’s Vehicle Crash Open Data. In: 2021 IEEE International Conference on Big Data (Big Data), Orlando, FL, USA, pp.6017-6019, December 15-18. Available at: https://doi.org/10.1109/BigData52589.2021.9672012.

-Službeni glasnik RS. 27/2018. Zakon o elektronskoj upravi. Belgrade: JP „Službeni glasnik“ (in Serbian).

Terzić, R. & Majstorović, M. 2019. Open data concept, its application and experiences. Vojnotehnički glasnik/Military Technical Courier, 67(2), pp.347-364. Available at: https://doi.org/10.5937/vojtehg67-19935.

Volpi, V., Ingrosso, A., Pazzola, M., Opromolla, A. & Medaglia, C.M. 2014. Roma Crash Map: An Open Data Visualization Tool for the Municipalities of Rome. In: Yamamoto, S. (Eds.) Human Interface and the Management of Information. Information and Knowledge in Applications and Services. HIMI 2014. Lecture Notes in Computer Science, 8522. Cham: Springer. Available at: https://doi.org/10.1007/978-3-319-07863-2_28.

Published
2023/06/08
Section
Original Scientific Papers