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.6+

Install

$ pip install convpandas

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

Usage

csv2xlsx

Convert csv file to xlsx file.

$ convpandas csv2xlsx in.csv out.xlsx

Options

Options:
  --sep TEXT                   Delimiter to use when reading csv.  [default:,]
  --encoding TEXT              Encoding to use when reading csv. List of Python 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: utf-8]

xlsx2csv

Convert xlsx file to csv file.

$ convpandas xlsx2csv in.xlsx out.csv
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.

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.1.1.tar.gz (4.3 kB view hashes)

Uploaded Source

Built Distribution

convpandas-0.1.1-py3-none-any.whl (5.6 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