jampoole
Joined 13 years ago
Joined 13 years ago
Early product vision was for handling merging and organizing csv files quickly and easily.
As time has gone on, I've pivoted and expanded to a full-fledged CSV importer which (bonus) includes multiple file merging support and a pretty cool UI for mapping.
Looking for as much feedback as I can to enhance it even more.
The free (sandbox) option is for trying it out. You can do everything, but it's limited to 100 records output per file.
I'm very open to suggestions on pricing. Was attempting to make it easy, but maybe not the best look:)
Funny thing is several years ago I made a very similar tool to what you pointed out above written entirely in bash/awk and is also blazing fast.
That's where I got the idea for this online tool. I wanted to create the same exact concept of working with files locally without having to open up a terminal/console.
True, you can do this with many languages like python (quite easily with pandas as you pointed out) or with awk, perl, even cat (minus ordering) etc. For more power users Excel Power Query is your friend, but as you know these require script setup and memory considerations.
This tool is geared for ease of use anyone can do without the fuss of custom scripts and/or setups and for the most part almost zero memory concerns as the output is being written on the fly.
For example if you had two csv files...
[File1.csv]
Id,ProductId
1,200
2,300
[File2.csv] ProductId,Name,Id
400,NameFor400,3
500,NameFor500,4
Final output would be...[Output.csv]
Id,ProductId,Name
1,200,""
2,300,""
3,400,NameFor400
4,500,NameFor500
With that said, thanks for commenting! I will add an option for "No Header" files, or maybe even auto detect for these situations and do a straight merge:)Here's how it's different than other sites out there:
-It's totally open and anonymous (e.g. no registration and no login). By removing logging in, people (including myself) are much more apt to actually providing salary information.
-Each entry is timestamped and displayed for indication of staleness when the time comes. You'll be able to better make judgements of what the current salaries are based on that, including cost of living increases per date, etc.
-The same person can continue to add salary info anytime (for raises, job movement, etc.) because it's always being tracked so this shouldn't destroy the integrity.
-The audience has a voice in each salary submission by having the opportunity to flag and comment for each.
-Lastly, this site is totally crowdsourced, however as mentioned above there's zero login. Also a lot of the other sites are only basing salaries on stats or taking from visa databases which is not what this site is about it's all about real entries.
Thanks for viewing!