fddf | Fast data dupe finder | Hashing library

Well, it was a little hard to debug because the code is confused, but here I have a simpler solution and I don't know if it works for you. Anyway I'll let it below, the explatation of every line is there and if you have some doubts just let me know :)

Not sure if this is what you're looking for, but you can instead try:

result.groupby('type')['post'].agg(pd.Series.mode) from https://stackoverflow.com/a/54304691/5323399

If you want to look at more than a single top value, you can try a lambda function with value_counts() like listed for that question, only adding nlargest() to the end of the function.

This would do the trick

I can not test this because I don't have the datasets, but the code below will hopefully make the main idea clear. In code below, all_post denotes all samples combined, both result.post and docs_test according to your example, and n is assumed to be 10.

The mistake I believe is in these lines:

Maybe not the more pythonic way but the first that came to my mind

The solution was on the documentation from Telerik. https://docs.telerik.com/kendo-ui/api/javascript/dataviz/ui/chart/configuration/categoryaxis.labels

The problem is that LineInformation is not a child of HeaderInformation, but a sibling, so use the .. to get the parent element, and so then get the siblings, like so....

Not to discourage you from learning VBA (it's a great skill to have!) but I figured I'd whip up a VBA Function that you can start using with your data right away... Once we confirm that everything's working I'll give you some links to explain how this (simple) function works, along with some other good beginners' resources. :)

I have never worked with Chinese characters but I did a bit of research. Western alphabets generally come from a set of 255 characters called ASCII. Eastern alphabets come from a set of 65533 characters called Unicode. ASCII characters each take 1 byte of storage space, whereas Unicode characters take up 2 bytes each.

What does this mean to a text function like the one I put together? I'm not entirely sure! Apparently I am supposed to use different builtin formulae than I normally would, but my code wouldn't work with the alternate method, yet seems to work just fine the way I've always done things.

This may be different with your "complete" data-set, combined with your computer's language settings compared to North America. Theoretically, it should work just fine, but I'd suggest that when you start using it, count a bunch of different cells manually so that you can compare the numbers that the function gives you, and let me know if there are discrepancies. (If you're list isn't "top secret", I'd kind of like to have a copy if you wouldn't mind; this is all foreign to me [pun intended] and I'd like to understand more about the differences data-wise.)

A small group of Chinese characters are not part of the Unicode standard yet, but apparently they are rarely used anyways (usually for place names?) but you should keep an eye on that. Again, it shouldn't be an issue - in theory - because suspect that "if they aren't in Unicode, your computer won't have them either" (I think!) Here is a link to a list of characters in question.

Anyhow, the only way to find out if it's working like it should is to try it out with your full set of data!

1. Select the VBA Code below, and hit Ctrl+C to copy.

2. Go to your Excel workbook, and hit Alt+F11 to open the VBA Editor (aka VBE).

3. Click the Insert menu in the VBE, and choose Module.

4. Hit Ctrl+V to paste the code.

5. Click the Debug menu in the VBE, and choose **Compile Project". This checks the code for errors. Ideally "nothing" will happen, meaning it's error-free & good to go.

6. Close the VBE window with the " ✘ " in the top-right corner.

7. Save your workbook, and the new functions are ready to use! See the screenshot below for example usage.

.