convpandas 0.3.0

Convert file format with pandas

convert-fileformat-with-pandas

Convert file format with pandas.

Requirements

• Python 3.7+

Install

$ pip install convpandas

https://pypi.org/project/convpandas/

Usage

csv2xlsx

Convert csv file to xlsx file.

$ convpandas csv2xlsx --help
Usage: convpandas csv2xlsx [OPTIONS] [CSV_FILE]... XLSX_FILE

  Convert csv file to xlsx file.

Options:
  --sep TEXT                   Delimiter to use when reading csv.  [default:,]

  --encoding TEXT              Encoding to use when reading csv. List of Python standard encodings. (https://docs.python.org/3/library/codecs.html#standard-encodings) [default: utf-8]

  --quotechar TEXT             The character used to denote the start and end of a quoted item when reading csv.

  --string_to_numeric BOOLEAN  If true, convert string to numeric. [default:true]

Convert in.csv to out.xlsx .

$ convpandas csv2xlsx in.csv out.xlsx

When CSV_FILE is - , STDIN is used for input.

$ convpandas csv2xlsx - out.xlsx < in.csv

Convert in1.csv and in2.csv to out.xlsx . Sheet name is csv filename without its' suffix.

$ convpandas csv2xlsx in1.csv in2.csv out.xlsx

If --sheet_name is specified, sheet name is set.

$ convpandas csv2xlsx in1.csv in2.csv out.xlsx --sheet_name foo bar

xlsx2csv

Convert xlsx file to csv file.

$ convpandas xlsx2csv --help
Usage: convpandas xlsx2csv [OPTIONS] XLSX_FILE CSV_FILE

  Convert xlsx file to csv file.

Options:
  --sheet_name TEXT  Sheet name when reading xlsx. If not specified, read 1st sheet.

  --sep TEXT         Field delimiter for the output file.  [default: ,]

  --encoding TEXT    A string representing the encoding to use in the output file.  [default: utf-8]

  --quotechar TEXT   Character used to quote fields. 

  --help             Show this message and exit.

Convert in.xlsx to out.csv .

$ convpandas csv2xlsx in.xlsx out.csv

When CSV_FILE is - , write to STDOUT.

$ convpandas csv2xlsx in.xlsx -
name,age
Alice,23

With specifying --sheet_name, you can select sheet name that you want to convert.

$ convpandas csv2xlsx in.xlsx out.csv --sheet_name sheet2