Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / simonw/csvs-to-sqlite issues and pull requests

#98 - fix and format by ruff

Pull Request - State: open - Opened by YoshitakaNaraoka 10 months ago

#97 - Fran

Issue - State: closed - Opened by OliverSchmelz 12 months ago

#96 - command fails if the filename has a square brackets

Issue - State: open - Opened by fgregg 12 months ago

#93 - Deprecated `iteritems()` attribute for Series

Issue - State: open - Opened by LuighiV over 1 year ago - 1 comment

#92 - Replace deprecated argument `error_bad_lines` and method `iteritems()` for pandas

Pull Request - State: open - Opened by LuighiV over 1 year ago - 4 comments

#91 - Don't touch tables that already exist?

Issue - State: open - Opened by chrismp almost 2 years ago

#90 - Column `filing_id` not found despite its manifest existence

Issue - State: open - Opened by MichaelTiemannOSC over 2 years ago - 1 comment

#89 - low_memory=False not a valid option

Issue - State: open - Opened by frafra over 2 years ago

#88 - error_bad_lines argument has been deprecated

Issue - State: open - Opened by frafra over 2 years ago - 11 comments

#87 - minor version 1.3.1: adds click 8.0 dep

Pull Request - State: open - Opened by dannguyen over 2 years ago - 1 comment

#85 - Optionally maintain checksums of CSV files for faster updates

Pull Request - State: open - Opened by dkaoster almost 3 years ago

#84 - Add syntax highlight to code blocks

Pull Request - State: closed - Opened by pauloxnet almost 3 years ago

#83 - Table name

Issue - State: open - Opened by Nur-A-Alam1997 almost 3 years ago

#82 - Try using cog to generate --help in README

Issue - State: closed - Opened by simonw almost 3 years ago - 2 comments
Labels: documentation, research

#81 - add "fixed-column" option

Pull Request - State: closed - Opened by williamrowell almost 3 years ago - 4 comments

#80 - Add support for Click 8.x

Issue - State: open - Opened by MarkusH over 3 years ago - 3 comments

#79 - Specify unique column?

Issue - State: open - Opened by jungle-boogie over 3 years ago

#78 - tab separator not recognized

Issue - State: open - Opened by verajosemanuel over 3 years ago

#75 - Add command line flag to skip existing table

Pull Request - State: closed - Opened by chrismp almost 4 years ago - 1 comment

#73 - outdated pandas dependency in setup.py?

Issue - State: closed - Opened by rtanglao about 4 years ago - 2 comments
Labels: enhancement

#72 - Ignore lines are start and end of file

Issue - State: open - Opened by psychemedia about 4 years ago - 1 comment

#71 - Adding Julian Days option (creates real columns in SQLite)

Pull Request - State: open - Opened by atiro about 4 years ago

#69 - csvs-to-sqlite 2.0: dropping Pandas in favour of sqlite-utils

Issue - State: open - Opened by simonw over 4 years ago - 6 comments
Labels: enhancement

#68 - Fix typo in README.md

Pull Request - State: closed - Opened by obi1kenobi over 4 years ago - 1 comment

#67 - Better documentation for command-line options

Issue - State: open - Opened by simonw over 4 years ago
Labels: enhancement, documentation

#66 - Progress bars would be useful

Issue - State: open - Opened by simonw over 4 years ago - 2 comments
Labels: enhancement

#65 - -d flag creates column as TEXT

Issue - State: closed - Opened by andy47 over 4 years ago - 1 comment
Labels: enhancement, wontfix

#64 - delete _fts tables with --replace-tables

Issue - State: open - Opened by JBPressac over 4 years ago - 2 comments
Labels: enhancement

#63 - Adjust for latest pandas

Pull Request - State: closed - Opened by jonringer over 4 years ago - 1 comment

#62 - leading zeroes / --shape args

Issue - State: open - Opened by jsfenfen over 4 years ago
Labels: enhancement

#61 - multiple CSV files and foreign keys

Issue - State: closed - Opened by JBPressac almost 5 years ago - 2 comments

#58 - added --just-strings feature, to import columns as strings by default

Pull Request - State: closed - Opened by dannguyen about 5 years ago - 1 comment

#57 - Cudos to Simon, great stuff!

Issue - State: closed - Opened by ljudva about 5 years ago - 1 comment

#56 - Drop support for Python 2.x

Pull Request - State: closed - Opened by simonw over 5 years ago

#55 - Drop support for Python 2.x

Issue - State: closed - Opened by simonw over 5 years ago - 2 comments

#54 - Bump pandas version to 0.25.x

Pull Request - State: closed - Opened by simonw over 5 years ago - 2 comments

#53 - Extracting multiple columns into the same table

Issue - State: closed - Opened by psychemedia over 5 years ago - 1 comment

#52 - pandas version is pinned at less than current release

Issue - State: closed - Opened by psychemedia over 5 years ago - 2 comments

#51 - Use ~= in setup.py but avoid pytest 5

Pull Request - State: closed - Opened by simonw over 5 years ago

#50 - Add `--skip-existing-tables` command line flag

Pull Request - State: closed - Opened by chrismp over 5 years ago - 2 comments

#49 - Add `--fts-all` command line flag

Pull Request - State: open - Opened by chrismp over 5 years ago - 1 comment

#47 - Process "Killed" Loading Large CSV in Binderhub

Issue - State: open - Opened by psychemedia over 5 years ago

#46 - Ability to read CSV from stdin

Issue - State: open - Opened by simonw almost 6 years ago

#45 - Add command line argument to control pandas.read_csv() na_filter option

Pull Request - State: open - Opened by dazzag24 almost 6 years ago

#43 - Multiple tables within the same CSV

Issue - State: open - Opened by Loran96 almost 6 years ago

#42 - Interpret all columns as TEXT data type

Issue - State: closed - Opened by tsundara almost 6 years ago - 4 comments

#41 - best_fts_version() cannot detect FTS5

Issue - State: closed - Opened by simonw about 6 years ago - 2 comments

#40 - Provide a means for importing CSVs contained inside a zip file

Issue - State: open - Opened by psychemedia about 6 years ago - 3 comments
Labels: enhancement

#39 - Update pinned requirements to make it easier to install with Python 3.7

Pull Request - State: closed - Opened by alasdairnicol about 6 years ago - 1 comment

#38 - Add support for loading CSVs directly from URLs

Pull Request - State: closed - Opened by betatim over 6 years ago - 6 comments

#37 - csvs-to-sqlite has a hard requirement on package versions.

Issue - State: closed - Opened by mratsim over 6 years ago - 4 comments

#36 - Documentation: write the manual

Issue - State: open - Opened by simonw over 6 years ago

#35 - FTS for extracted columns

Pull Request - State: closed - Opened by simonw over 6 years ago

#34 - Figure out a mechanism for interpreting dates as always in the 1900s

Issue - State: open - Opened by simonw over 6 years ago - 4 comments

#33 - -d / -dt options for parsing columns as dates

Issue - State: closed - Opened by simonw over 6 years ago

#32 - -c option should create fulltext index against value

Issue - State: closed - Opened by simonw over 6 years ago - 4 comments

#31 - ".\" added to table name in SQLITE database file

Issue - State: closed - Opened by joel0977 over 6 years ago - 4 comments

#30 - Need workaround for 'NULL' data

Issue - State: open - Opened by carlmjohnson almost 7 years ago - 1 comment

#29 - No create index option - please create new release

Issue - State: closed - Opened by jungle-boogie almost 7 years ago - 7 comments

#28 - Lookup table value column type should reflect --shape option

Issue - State: open - Opened by simonw almost 7 years ago

#27 - Maintain lookup tables in SQLite

Pull Request - State: closed - Opened by simonw almost 7 years ago

#26 - Learn to handle Excel

Issue - State: open - Opened by simonw almost 7 years ago

#25 - --shape option for specifying the "shape" of the resulting table

Issue - State: closed - Opened by simonw almost 7 years ago - 3 comments

#24 - Ability to specify columns that should be indexed

Issue - State: closed - Opened by simonw almost 7 years ago - 1 comment

#23 - Add --append-tables and --table-name options

Pull Request - State: closed - Opened by janimo almost 7 years ago

#22 - Ability to specify one or more columns as the primary key

Issue - State: closed - Opened by simonw almost 7 years ago - 1 comment

#21 - Process files sequentially to decrease memory footprint

Issue - State: closed - Opened by janimo almost 7 years ago - 1 comment
Labels: duplicate

#20 - Add --skip-errors option

Pull Request - State: closed - Opened by janimo almost 7 years ago - 1 comment

#19 - Less verbosity

Pull Request - State: closed - Opened by janimo almost 7 years ago

#18 - Help with CSV parsing errors

Issue - State: open - Opened by janimo almost 7 years ago - 1 comment

#17 - Lookup tables should be maintained directly in SQLite

Issue - State: closed - Opened by simonw almost 7 years ago - 3 comments

#16 - Handle giant CSV files

Issue - State: open - Opened by simonw almost 7 years ago - 4 comments

#15 - Add option for field quoting behaviour

Pull Request - State: closed - Opened by janimo almost 7 years ago

#14 - -c should be able to merge multiple columns into a single table

Issue - State: open - Opened by simonw almost 7 years ago - 4 comments

#13 - Add -s option to specify input field separator

Pull Request - State: closed - Opened by janimo almost 7 years ago - 2 comments

#12 - -f and -c don't work with single table to multiple columns

Issue - State: closed - Opened by simonw almost 7 years ago

#11 - `--split` for splitting extracted columns on their values

Issue - State: open - Opened by simonw almost 7 years ago - 3 comments

#9 - Get --fts to cooperate with --extract-column

Issue - State: closed - Opened by simonw almost 7 years ago

#8 - Use miniconda to speed up Travis CI builds

Pull Request - State: closed - Opened by simonw almost 7 years ago

#7 - --fts list-of-columns option

Issue - State: closed - Opened by simonw almost 7 years ago - 4 comments

#6 - Ensure foreign keys are created with indexes

Issue - State: closed - Opened by simonw almost 7 years ago - 1 comment

#5 - Columns are typed "REAL" if they are integers with some NaN/blanks

Issue - State: closed - Opened by simonw almost 7 years ago - 4 comments

#4 - Should accept URLs to CSV files as well as paths

Issue - State: closed - Opened by simonw almost 7 years ago - 2 comments
Labels: good first issue

#3 - Make sure key functionality can be imported and used as a library

Issue - State: open - Opened by simonw almost 7 years ago

#2 - Way of converting a specified column into a lookup table

Issue - State: closed - Opened by simonw almost 7 years ago - 3 comments

#1 - Allow appending files to an existing SQLite database

Issue - State: closed - Opened by simonw almost 7 years ago - 5 comments