Skip to main content

Convert file format with pandas

Project description

convert-fileformat-with-pandas

Convert file format with pandas.

Build Status PyPI version Python Versions

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

convpandas-0.3.0.tar.gz (6.2 kB view hashes)

Uploaded Source

Built Distribution

convpandas-0.3.0-py3-none-any.whl (7.9 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page