• Home
  • Search
  • A Performance Comparison of Microsoft Excel and Python for Tabular Data Analysis
  • https://doi.org/10.29304/jqcsm.2026.18.12585Copy DOI Icon

A Performance Comparison of Microsoft Excel and Python for Tabular Data Analysis

  • Abstract
  • Literature Map
  • Similar Papers
Abstract

Microsoft Excel is commonly treated as a simple spreadsheet program that is mainly applied to do simple calculations, and Python has become a common solution to complex data analysis based on the programming language. In this work, a technical performance analysis of Microsoft Excel and Python (Pandas) is provided as an attempt to assess their compatibility with basic data analysis functions. The comparison is done which consists of loading datasets, cleaning data, calculating features, aggregating and searching them. The main performance parameter used is execution time and measurements are taken at every processing phase so as to provide a detailed and equitable evaluation. To ensure a robust assessment, the methodology utilized two distinct transactional datasets: a medium-scale over 500000 records and a large-scale dataset over one million records. A key contribution of this work is the implementation of a search loop algorithm as a stress test, where execution time was measured for three specific scenarios: searching for a record at the beginning, at the end, and for a non-existent value. According to the experimental findings, Excel can efficiently handle all of the analyzed tasks and its execution time is as approximate Python as both systems are able to complete the tasks in an approximate time interval. Despite Python having more accuracy in procedures and measurements of time, more automation, and higher reproducibility due to code-based workflows, Excel has competitive analytical capabilities in interactive processing of data. These results underscore the idea that Microsoft Excel can no longer be viewed as an exclusively computational device, and instead of that, it can be viewed as a technically competent data analysis platform capable of performing similarly to Python on large-scaled analytical workloads.

Similar Papers
  • Research Article
  • Citations55

Performance Evaluation of C/C++, MicroPython, Rust and TinyGo Programming Languages on ESP32 Microcontroller

  • Dec 28, 2022
  • Electronics
  • Ignas Plauska +2
  • Research Article
  • Citations67

Analytical analysis of single-stage pressure relief valves

  • Jan 01, 2019
  • International Journal of Hydromechatronics
  • Sven Osterland +1
  • Conference Article
  • Citations54

Can execution time describe accurately the energy consumption of mobile apps? an experiment in Android

  • Jun 01, 2014
  • Luis Corral +3
  • Peer Review Report

Decision letter: THINGS-data, a multimodal collection of large-scale datasets for investigating object representations in human brain and behavior

  • Oct 26, 2022
  • Talia Konkle +1
  • Research Article

Unifying Algorithmic Performance: Insertion Sort Across Diverse Programming Paradigms

  • Jan 01, 2026
  • European Journal of Scientific Research and Reviews.
  • Md Islam +1
  • Research Article

Empirical Evaluation of Algorithm Performance: Addressing Execution Time Measurement Challenges

  • Jan 07, 2025
  • Informatica
  • Tomaž Dobravec
  • Research Article

Effect of Increase in Swayload on Unsymmetrically Loaded Portal Frame Structure at Lekki Using Slope Deflection Method

  • May 02, 2021
  • SSRN Electronic Journal
  • Equatorial Journals +2
  • Research Article
  • Citations4

TOF plotter—a program to perform routine analysis time-of-flight mass spectral data

  • Mar 01, 2004
  • Spectrochimica Acta Part B: Atomic Spectroscopy
  • Brad C Knippel +2
  • Research Article
  • Citations4

Using lotus 1–2–3 macros as grading assistants

  • Sep 01, 1989
  • Journal of Accounting Education
  • Thomas P Edmonds +1
  • Conference Article
  • Citations17

An Armature-Stator Contact Resistance Model for Explosively Driven Helical Magnetic Flux Compression Generators

  • Jun 01, 2005
  • Gerald Kiuttu +1
  • PDF
  • Research Article
  • Citations3

Design and Implementation of an Aspect-Oriented C Programming Language

  • Apr 29, 2024
  • Proceedings of the ACM on Programming Languages
  • Zhe Chen +2
  • Research Article
  • Citations4

Pengembangan Media Praktikum Virtual Analisis Logam Besi Secara Spektrofotometri UV-Vis Berbasis Microsoft Excel Sebagai Media Alternatif pada Praktikum Analisa Instrumen dan Pemisahan

  • Jul 20, 2022
  • Jurnal Pendidikan Sains Indonesia
  • Ibnu Khaldun* +2
  • Research Article
  • Citations10

Fringe pattern demodulation using the one-dimensional continuous wavelet transform: field-programmable gate array implementation

  • Feb 28, 2013
  • Applied Optics
  • Abdulbasit Abid
  • Research Article
  • Citations121

FFT-split-operator code for solving the Dirac equation in 2+1 dimensions

  • Feb 01, 2008
  • Computer Physics Communications
  • Guido R Mocken +1
  • Research Article

تأثیر قارچ مایکوریز، باکتری سودوموناس و اسیدهیومیک بر شاخصهای رشدی لوبیا (Phaseolus vulgaris L.)

  • Oct 05, 2017
  • SHILAP Revista de lepidopterología
  • ندا جدیدالااسلام +2
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.