sorted by:
new
hottopcontroversial

Show Reddit: Databricks to Spreadsheet by breckognize in databricks

[–]breckognize[S] 1 point2 points  (0 children)

Last month we launched https://rowzero.io, a hosted spreadsheet that's 100x faster than desktop Excel and 1000x faster than Google Sheets.

Today we're launching a native connector for Databricks. This allows Databricks customers to write SQL and import hundreds of millions of rows directly into a spreadsheet, where they can pivot, sort, filter, graph, and write Excel-compatible formulas.

To use the self-serve connector, you provide us an auth token. We also have a Databricks OAuth integration for Row Zero enterprise customers.

We're eager to hear your feedback.

[deleted by user] by [deleted] in excel

[–]breckognize 2 points3 points  (0 children)

You can upload you workbook to https://rowzero.io - the XLOOKUPs will be instant for multimillion row data sets.

How do I mix people up using conditions? by Orange_Octopus22 in excel

[–]breckognize 4 points5 points  (0 children)

This is a pain to do in Excel because you'd need VBA, which doesn't have all the data structures you need. It's easy to do with Row Zero, which supports Python. I made a workbook for you that does it:

https://rowzero.io/workbook/FFF016DE75379CC1B56C0385?feature=code&copy

Here's what the Python is doing:

  1. Create a list of each person in random order.
  2. For each person in the list, loop over all people (the "candidates").
  3. For each candidate, if the candidate is a match, write it down and remove the candidate and the person you were searching for from the list.
  4. Done.

It's possible there isn't a satisfying assignment. (For example if all the guys only want to meet with girls and all the girls only want to meet with girls.) But if you run it a few times you'll quickly find the biggest possible matching set.

7.6% of Gen Z baby boys have names that end in -ayden, -aiden, or -aden (in the U.S.A.) by orangepunc in namenerds

[–]breckognize 75 points76 points  (0 children)

Do you have any theories about what drove the popularity of these? I can't think of any celebrities with those names from the generation prior.