ChatGPT, Python, and Microsoft Excel

Kaique Sbampato; Humberto Arruda; Édison Renato Silva

doi:10.5195/jmla.2025.2065

Authors

Kaique Sbampato Industrial Engineering Department and Production Engineering Program, Universidade Federal do Rio de Janeiro, Rio de Janeiro, Brazil. https://orcid.org/0000-0002-3287-9318
Humberto Arruda Production Engineering Program, Universidade Federal do Rio de Janeiro, Rio de Janeiro, Brazil. https://orcid.org/0000-0002-3064-809X
Édison Renato Silva Industrial Engineering Department and Production Engineering Program, Universidade Federal do Rio de Janeiro, Rio de Janeiro, Brazil. https://orcid.org/0000-0002-4994-7057

DOI:

https://doi.org/10.5195/jmla.2025.2065

Keywords:

ChatGPT, Microsoft Excel, Python

Abstract

This article examines how the integration of ChatGPT, Python, and Microsoft Excel can significantly enhance the productivity of medical librarians. These tools provide a powerful framework for automating tasks, processing large datasets, and generating actionable insights. ChatGPT, with its advanced natural language processing, helps automate Python script generation and improve data processing in Excel, streamlining workflows and enabling more precise service delivery. Practical applications demonstrate improvements in information retrieval, data management, and research support. The results show that, despite some integration challenges, these technologies have the potential to greatly elevate the efficiency and effectiveness of librarians in managing healthcare data.

References

A. Spencer and J. Eldredge, "Roles for librarians in systematic reviews: A scoping review," Journal of the Medical Library Association, vol. 106, no. 1, 2018. doi:10.5195/jmla.2018.82.

P. P. Ray, "ChatGPT: A comprehensive review on background, applications, key challenges, bias, ethics, limitations and future scope," Internet of Things and Cyber-Physical Systems, vol. 3, pp. 121–154, 2023. doi:10.1016/j.iotcps.2023.04.003.

M. Sallam, "ChatGPT Utility in Healthcare Education, Research, and Practice: Systematic Review on the Promising Perspectives and Valid Concerns," Healthcare, vol. 11, no. 6, p. 887, 2023. doi:10.3390/healthcare11060887.

A. Loxley, ChatGPT Millionaire Bible: Unleash Your Potential and Boost Your Success in the Digital Age Mastering the Power of ChatGPT, Independently published, 2023.

E. A. M. Van Dis, J. Bollen, W. Zuidema, R. Van Rooij, and C. L. Bockting, “ChatGPT: five priorities for research,” Nature, vol. 614, no. 7947, pp. 224–226, Feb. 2023, doi: 10.1038/d41586-023-00288-7. PMID: 36737653.

H. Kissinger, E. Schmidt, and D. Huttenlocher, The Age of AI: And Our Human Future, Back Bay Books, New York, 2022.

ChatGPT, Python, and Microsoft Excel

Authors

DOI:

Keywords:

Abstract

References

Downloads

Published

Issue

Section

License

Current Issue