Lightlines
By davila7

excel analysis

davila72.6k installs

Turn Excel data into clean reports, pivots, and charts.

What it does

Analyzes Excel spreadsheets, cleans and combines data, and creates formatted workbooks, pivot tables, and charts.

When to use it

Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.

How to use it

Give it spreadsheet files and the desired work; it analyzes the data or creates workbook and chart files in the project.

What you provide

  • Your files

Latest review

What you need · 6

Requires Python to run the documented analysis code.

Uses pandas as the primary package for data analysis and manipulation.

Uses openpyxl for Excel file creation and formatting.

Enables reading older .xls files.


Access · 0

No additional actions listed.