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.1.tar.gz
(8.4 kB
view hashes)
Built Distribution
Close
Hashes for csv_to_xls-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6e5114f18de64b0a82ea9a6d15c853a48e56b0cae95c429f18e8c0ff02f14061 |
|
MD5 | 6ba462f32b4fee1a19c87edec6e3824c |
|
BLAKE2b-256 | 91c0c3100ec8a59faa5f8c75acf190da7aaed6f0b4d74c5d108495da1374dbce |