Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
narush
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
11 ms
·
31.
▲
by
narush
2y ago
Woof. Always the words you stare at the most that are wrong... will update that demo video when I get the chance, but might be a bit :) Good thing Pyoneer generates test cases for the formulas it generates! No need to trust my spelling abil
32.
▲
by
narush
2y ago
Thanks for the feedback. I've updated the landing page to prominently display this language - see the how it works section.
33.
▲
by
narush
2y ago
Yep - this is a one-way process! You can think of it like an eject from Excel, in the best case. The devs we've worked with so far have the goal of replacing the Excel process - inheriting it from the team that runs it manually, and au
34.
▲
by
narush
2y ago
Sure thing - thanks for the good thoughts! We're still working on Mito - it's not a retired product by any means. Pyoneer is just another stab at the same problem for a different user group. MMR-wise, we scaled to profitability. P
35.
▲
by
narush
2y ago
Check my comment to OP on this thread - hopefully this is answers why we don't do this! I will say: we are considering some more approaches from traditional compilation / transpilation. I think these are very compatible!
36.
▲
by
narush
2y ago
Copying and pasting from a comment below -- we considered this heavily during our MVP, but in practice "moving an Excel process to Python" does not just mean executing an Excel file through Python. This pretty much doesn't re
37.
▲
by
narush
2y ago
Thanks for the link! We looked into existing libraries for Excel formula execution - this library as an awesome example! We considered using this, but to copy from our MVP spec: The easiest thing to do is to replicate Excel’s execution engi
38.
▲
by
narush
2y ago
You 100% own all Python code that you download from Pyoneer. Sorry for the lack of clarity here! You're welcome to: 1. Edit it to fix up places where it can't translate fully. 2. Send it to your colleagues and tell them you wrote
39.
▲
by
narush
2y ago
Totally on the roadmap, but not sure when yet! The problem is data gets into these mega-excels through all sorts of funky routes... and I really do mean funky :) 1. PowerQuery: this is defined statically in the notebook so is detectable by
40.
▲
by
narush
2y ago
Currently: 1. Data remains stored in the excel file. The generated script pulls the raw data directly from the notebook - but it's a single read_xlsx call. So if you want to switch it out for an API call, db read, whatever - it's
41.
▲
by
narush
2y ago
Yeah, we built this because we wished we had it! I've spent literally thousands of hours reimplementing Excel workbooks in Python as support for our previous shot at this problem - which was a spreadsheet that generates Python code as
42.
▲
by
narush
2y ago
> What customer discovery have you done so far? Me and my two cofounders spend the past 4 years working on Mito ( https://trymito.io ) -- where our customers are primarily large finance shops (including some bulge bracket banks
43.
▲
Show HN: Excel to Python Compiler
(pyoneer.ai)
79 points
by
narush
2y ago
|
36 comments
44.
▲
by
narush
3y ago
This is an excellent blog post - I'd never heard of Great Tables before, and I'm a newly minted fan! > confronted with an all-too-familiar dilemma: copy your data into a tool like Excel to make the table, or, display an otherwi
45.
▲
by
narush
3y ago
The OG Nick Bostrom argument [1] makes an argument for simulation theory with some reasonably simple math you can see in the paper with only a few variables: - `f_p` - Fraction of all human-level technological civilizations that survive to
46.
▲
by
narush
3y ago
I'm building an open-core spreadsheet currently, and pivot tables are by far our number-one data transformation feature. By like 3x-1x. This is compared to even formulas (shockingly! but this is also a function of our audience). In the
47.
▲
by
narush
3y ago
> The case-control study collected retrospective dietary “recalls,” or written estimates, of diet beverage and aspartame consumption during pregnancy or breastfeeding from mothers of 235 offspring with autism spectrum disorder, and 121 o
48.
▲
by
narush
3y ago
We've thought about this question a lot at Mito[1], where we're building a spreadsheet that code-gens Python code for you as you edit it. For us, it's been useful to decompose the question of "what code-gen is good for&q
49.
▲
by
narush
3y ago
We should stop climate change. We should also be careful about developing the capabilities of new technology that will put us in similarly precarious situations going forward.
50.
▲
Building Your Life Away: Reflections on Building a Spreadsheet
(blog.trymito.io)
2 points
by
narush
3y ago
|
0 comments
51.
▲
by
narush
3y ago
If you're interested in using React-style frontend programming in Python but want an experience / API closer to that of React, I recommend checkout out Reacton [1]. Similarly to this library, it gives you a `@component` decorator
52.
▲
by
narush
3y ago
I guess you could build an AST from the Python code and eval if it's successful. No gaurentee the code will run, of course (you could always get an error). In general, it feels it's halting problem hard to determine if any general
53.
▲
Show HN: Verify LLM Generated Code with a Spreadsheet
83 points
by
narush
3y ago
|
14 comments
54.
▲
by
narush
3y ago
To join the quote-and-respond masses in the comments: > AI will be the single most significant driving factor of change in the world. If we solve AGI (or achieve intelligence close to AGI), we'll likely solve most of the world'
55.
▲
by
narush
3y ago
Very cool! For anyone wondering, before 2003 Excel only supported 65,536 rows. It now has a hard limit 1,048,576 rows. Google sheets is a bit harder to figure out -- it doesn't have an explicit row limit, but does have a cell limit of
56.
▲
by
narush
3y ago
I think the biggest area for growth for LLM based tools for data analysis is around helping users _understand what edits they actually made_. I'm a co-founder of a non-AI data code-gen tool for data analysis -- but we also have a basic
57.
▲
by
narush
3y ago
> We can still regulate the new ai tools, but we must act quickly. Whereas nukes cannot invent more powerful nukes, ai can make exponentially more powerful ai. I mean, maybe. Sure, LLMs can currently code shockingly well, and LLMs are ju
58.
▲
by
narush
3y ago
Cool! Just tried it out with my partner (in the process of designing their living room in a new place). UX suggestion: let me select a new style without having to re-upload the photo. We wanted to check out a bunch of styles on the same pho
59.
▲
Lessons learned from adding ChatGPT to our mature product
(blog.trymito.io)
39 points
by
narush
3y ago
|
1 comments
60.
▲
by
narush
4y ago
Mito co-founder here - thanks for the mention! OP you can check out Mito here [1]. Tldr: Mito is a spreadsheet that you can use to edit pandas dataframes, from directly within a Jupyter notebook. For every edit you make, Mito generates the
More ›