Skip to content

command-line tools for large flat-files: for managing tables that're too large for EXCEL (or even too large to fit into RAM)

License

Notifications You must be signed in to change notification settings

bcgov/flatfile-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

flatfile_tools

Scripts for wrangling arbitrarily large tables AKA "flat files"; python 2 and 3, C/C++ and R syntax are leveraged. Python3 now supported for building

  • conversion from fixed-width format to csv
  • parsing, slicing and some statistics manipulations included
    • column mode operations and summarization for discrete variables
  • robustness to extremely large file sizes (tested with csv files 100's of GB in size)

requirements

Presently the scripts are tested for Cywin ("linux for Windows" platform) with gnu g++ and python 2 and 3 both installed, under a Windows 10 environment

Instructions

Place a copy of the files in a folder named /bin in your private/home folder and click on bash.bat

License

Copyright 2019 Province of British Columbia

Licensed under the Apache License, Version 2.0 (the "License"); you mayn't use these files except in compliance with the License.

You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0

Unless req'd by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

See the License for specific language governing permissions and limitations under the License.

About

command-line tools for large flat-files: for managing tables that're too large for EXCEL (or even too large to fit into RAM)

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published