convert csvs to excel
Project description
csv_to_xls
Install
pip install csv_to_xls
How to use
When you install csv_to_xls
you will get a cli tool named csv2xls
:
!csv2xls --help
usage: csv2xls [-h] [--file_glob FILE_GLOB] [--out_file OUT_FILE] [--recursive]
[--symlinks] [--file_re FILE_RE] [--folder_re FOLDER_RE]
[--skip_file_glob SKIP_FILE_GLOB] [--skip_file_re SKIP_FILE_RE]
[--skip_folder_re SKIP_FOLDER_RE]
path
Convert csv file(s) into an excel file, if multiple csvs put on tabs.
positional arguments:
path path to searching for *.csv files
optional arguments:
-h, --help show this help message and exit
--file_glob FILE_GLOB Only include files matching glob (default:
*.csv)
--out_file OUT_FILE output excel file (default: output.xlsx)
--recursive search subfolders (default: False)
--symlinks follow symlinks? (default: False)
--file_re FILE_RE Only include files matching regex
--folder_re FOLDER_RE Only enter folders matching regex
--skip_file_glob SKIP_FILE_GLOB Skip files matching glob
--skip_file_re SKIP_FILE_RE Skip files matching regex
--skip_folder_re SKIP_FOLDER_RE Skip folders matching regex,
Example
Consider the below csv files:
!ls _tests/
addresses.csv biostats.csv faithful.csv hw_200.csv tally_cab.csv
To merge these csvs into one excel file named merged.xlsx
:
!csv2xls _tests/ --out_file merged.xlsx
We can see there is a worksheet for each filename:
import pandas as pd
pd.ExcelFile('merged.xlsx').sheet_names
['addresses', 'biostats', 'hw_200', 'tally_cab', 'faithful']
Let’s say we want to skip the biostats.csv
file, we can use the
--skip_file_re
arg:
!rm -f merged.xlsx
!csv2xls _tests/ --out_file merged.xlsx --skip_file_re 'biostats*'
Now that particular sheet is not there:
pd.ExcelFile('merged.xlsx').sheet_names
['addresses', 'hw_200', 'tally_cab', 'faithful']
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
csv_to_xls-0.0.2.tar.gz
(8.5 kB
view hashes)
Built Distribution
Close
Hashes for csv_to_xls-0.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1ed3ffba978e5484c76bf7d5fa6af3897fbee24e728add8f8c05fda6d335720c |
|
MD5 | 115bf8f475c909e229e95103dee307bb |
|
BLAKE2b-256 | b9a17720fbf9d6e069c57a638baf9a475594bfd80c3b8fa10039e1c9d3e39598 |