pandas Archives - Mechanical Duniya

Python for Beginners: How to Create an Excel File Using Pandas and PyCharm

June 23, 2026June 22, 2026 by Dr. Paresh Gujarati

Data is everywhere, but staring at thousands of lines of raw numbers or text can make anyone’s head spin. That is why spreadsheets like Microsoft Excel remain the global language of business. But what if you could use code to generate, update, and manipulate those Excel files automatically? Enter Python. Python is one of the … Read more

MS Excel Vs Python with Pandas library

June 19, 2026 by Dr. Paresh Gujarati

For decades, the standard operating procedure for a mechanical engineer concluding a laboratory or field test has been uniform: copy the raw data from the data acquisition (DAQ) system, locate the corresponding .csv or .xlsx files in a crowded project folder, and double-click to open them in Microsoft Excel. Let’s see how to deal with … Read more