py-xsv 0.0.2

Reading -sv files and writing them to dataframes

py-xsv

py-xsv is a Python utility for reading -SV files (CSV, TSV, etc.) and converting them into dataframes.

---

Features

• Auto-detect delimiters in CSV, TSV, or other -SV files.
• Read files into:
  • List of dictionaries (content_dict)
  • List of lists (content_list)
• Extract column data easily (column).
• Quickly access top/bottom rows (head, tail).
• Get dimensions (length_width) and headers (headers).
• Save -SV file to pandas DataFrames (save_df).

---

Installation

pip install py-xsv

This needs Python 3.9 or more.

---

Docs

Read a CSV/TSV file as a list of dictionaries

import py_xsv
data = py_xsv.content_dict("data.csv")
print(data[:5])

Read as a list of lists

import py_xsv

data = py_xsv.content_list("data.csv")
print(data[:5])

Detect dilimiter manualy

import py_xsv

with open("data.csv", "r") as f:
    lines = f.readlines()

delimiter = py_xsv.detect_delimiter(lines)
print(f"Detected delimiter: {delimiter}")

Work with columns and headers

import py_xsv

data = py_xsv.content_dict("data.csv")
print("Headers:", py_xsv.headers(data))
print("First column:", py_xsv.column(data, "ColumnName"))

Quick access to top and bottom rows

import py_xsv

data = py_xsv.content_list("data.csv")
print("Top 5 rows:", py_xsv.head(data, 5))
print("Bottom 5 rows:", py_xsv.tail(data, 5))

Save data to a pandas DataFrame

import pandas
import py_xsv

data = py_xsv.content_dict("data.csv")
df = py_xsv.save_df(data)

You need to have import pandas before doing this

Exceptions

• py_xsv.NotSVFileError - Used when a non -sv file is given
• py_xsv.PandaError - Errors while using pandas
• py_xsv.Error - Generic Error

---

License

This is licensed under the WTFPL.

This means that you have permission for:

• Commercial use
• Modification
• Distribution
• Private use
• Everything basically

Under no conditions or limitations

---