DataProfiler
XlsxWriter
Our great sponsors
DataProfiler | XlsxWriter | |
---|---|---|
61 | 11 | |
1,349 | 3,467 | |
2.6% | - | |
7.0 | 8.0 | |
about 14 hours ago | 26 days ago | |
Python | Python | |
Apache License 2.0 | BSD 2-clause "Simplified" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
DataProfiler
-
Data Profiler 0.9.0 -- offering a massive improvement to memory usage during profiling of large datasets
Great call out -- would you be willing to write up an issue for that on the repo? Thank you! https://github.com/capitalone/DataProfiler/issues/new/choose
- FLiPN-FLaNK Stack Weekly for 20 March 2023
-
Miller – tool for querying, shaping, reformatting data in CSV, TSV, and JSON
My team built a similar tool in Python to load any delimited file, json, parquet and Avro with one command:
https://github.com/capitalone/DataProfiler
Effectively loads anything into a dataframe
-
PyTorch vs. TensorFlow in 2022
The thing is, tensorflow has more ability to run cross platform.
I help maintain https://github.com/capitalone/DataProfiler
Our sensitive data detection library is exported to iOS, android, and Java; in addition to Python. We also run distributed and federated use cases with custom layers. All of which are improved in tensorflow.
That said, I’d use pytorch if I could. Simply put, it has a better user experience.
-
Fast CSV Processing with SIMD
I really should write up how we did delimiter and quote detection in this library:
https://github.com/capitalone/DataProfiler
It turns out delimited files IMO are much harder to parse than say, JSON. Largely because they have so many different permutations. The article covers CSVs, but many files are tab or null separated. We’ve even seen @ separated with ‘ for quotes.
Given the above, it should still be possible to use the method described. I’m guessing you’d have to detect the separators and quote chars first, however. You’d have to also handle empty rows and corrupted rows (which happen often enough).
-
Dask – a flexible library for parallel computing in Python
Having used both ray, dask, and writing custom threads, my personal view is that while there are advantages I wouldn’t want to use any of these unless absolutely necessary.
My personal approach for most of these tasks are to try to break down the problem to be as asynchronous as possible. Then you can create threads.
The nice thing about dask is really the way you can effectively use it as a pandas dataframe.
Having said that, we opted to write our own parallelization for this library:
https://github.com/capitalone/DataProfiler
As opposed to using the dask frame. Effectively, it’s a high overhead and easier to maintain the threading ourselves given the particular approaches taken.
That said, if I was working with large pandas dataframes, id likely use dask. For large datasets which couldn’t be stored in memory of use ray.io
-
Launch HN: Metaplane (YC W20) – Datadog for Data
My team has worked on a library for a similar purpose:
https://github.com/capitalone/DataProfiler
Load any document, profile and monitor the profiles for changes that would impact downstream applications.
Very common problem, you all are in a great space! Very interested and will check out!
-
Show HN: Graphsignal – Production Model Monitoring
We built a very similar application internally with our open source library: https://github.com/capitalone/dataprofiler
Effectively, you can monitor changes between profiles:
# Load a CSV file
-
Miller CLI – Like Awk, sed, cut, join, and sort for CSV, TSV and JSON
Not exactly the same, but we wrote a library to easily load any delimited type of file and finds header (even if not first row). It also works to load JSON, Parquet, AVRO and loads it into a dataframe. Not CLI exactly, but pretty easy:
https://github.com/capitalone/dataprofiler
Anyway, pretty interesting Miller CLI
XlsxWriter
-
Streamlining Data Export to Excel: A comprehensive guide to using Python, Nodejs, PHP.
openpyxl
-
Need your thoughts on best way to execute a code that pulls specific data points in pdf and places them into specific spots on an excel sheet
If you must, use xlsxwriter to write it directly into the Excel spreadsheet. This is kind of a pain. If you can get away with, say, writing the data to a CSV and then copy-pasting it into the Excel sheet, you should do that instead because it's so much more conceptually simple and works directly with the Python data structures that you parsed in Step 3. Automation doesn't have to be completely fire-and-forget to save you a ton of time!
-
The Best GitHub Repositories For Django Developers.
xlsxwriter…
-
Show HN: Sheet2dict – simple Python XLSX/CSV reader/to dictionary converter
For the opposite direction, I have had good luck with the XlsxWriter library
-
Excel Never Dies
I'm less familiar with the R ecosystem, but there are tools in the Python world to go that direction -- https://xlsxwriter.readthedocs.io/
- Is there a tool to convert AWS json data ( SGs, NACLs, etc) into a spreadsheet that is more human readable?
What are some alternatives?
openpyxl
xlwt
xlwings - xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.
pyexcel - Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files
ydata-profiling - 1 Line of code data quality profiling & exploratory data analysis for Pandas and Spark DataFrames.
python-docx - Create and modify Word documents with Python
ExcelJS - Excel Workbook Manager
python-pptx - Create Open XML PowerPoint documents in Python
docxtpl - Use a docx as a jinja2 template
libxlsxwriter - A C library for creating Excel XLSX files.
unoconv - Universal Office Converter - Convert between any document format supported by LibreOffice/OpenOffice.
php-ext-xlswriter - 🚀 PHP Extension for creating and reader XLSX files.