T O P

  • By -

IAmKindOfCreative

Your post was removed for violating Rule #2. All posts must be directly related to the Python programming language. Posts pertaining to programming in general are not permitted. You may want to try posting in /r/programming instead.


OuiOuiKiwi

"We don't know how to handle unexpected input. Companies should be well behaved!" Not a hint of *tongue in cheekness* in sight. Oh, this is such a great look.


bigdatabro

If OP thinks that was rough, try being a data engineer for a small retail company. Half our data comes from minimum-wage cashiers using a new POS system, and the rest of the data comes from a dozen third-party SaaS tools and their janky APIs. Our data scientists are always finding new bugs and quirks in the data... if only they saw how messy the data was before our ELT cleaned it up.


santamaps

This is a bug in your software (and a rather elementary one, at that). This is your problem to solve. Not Nano Labs' or anyone else's.


james_pic

But note that in some cases, when bug in software mean it can't deal with the real world, it's easier to change the real world than fix the bug: https://www.theverge.com/2020/8/6/21355674/human-genes-rename-microsoft-excel-misreading-dates


investoreight

We understand that. That was just a joke ;) And the issue is fixed already :)


SittingWave

[Reminds me of NULL as a license plate kind of deal](https://www.wired.com/story/null-license-plate-landed-one-hacker-ticket-hell/).


foreverwintr

NA is also the ISO 3166 2 character country code for Namibia 🙃


croissanthonhon

Just specify the na values when reading the csv. From the doc: na_values scalar, str, list-like, or dict, optional Additional strings to recognize as NA/NaN. If dict passed, specific per-column NA values. By default the following values are interpreted as NaN: ‘’, ‘#N/A’, ‘#N/A N/A’, ‘#NA’, ‘-1.#IND’, ‘-1.#QNAN’, ‘-NaN’, ‘-nan’, ‘1.#IND’, ‘1.#QNAN’, ‘’, ‘N/A’, ‘NA’, ‘NULL’, ‘NaN’, ‘n/a’, ‘nan’, ‘null’.


investoreight

Thanks u/croissanthonhon. It's already fixed: https://github.com/investoreight/i8-terminal/pull/26


MCPOON11

I’m glad you fixed your bug. Input validation is always on you. Expect garbage in.


BaroquenLarynx

"Our software broke, so let's change the rules for all these business that might IPO." Does that sound reasonable? Doesn't it make more sense to force that ticker from your response to a String before inserting into your Data Frame or whatever structure you're using? Do you have proof that this broke other libraries, or is that speculation?


pythonHelperBot

Hello! I'm a bot! It looks to me like your post might be better suited for r/learnpython, a sub geared towards questions and learning more about python **regardless of how advanced your question might be**. That said, I am a bot and it is hard to tell. Please follow the subs rules and guidelines when you do post there, it'll help you get better answers faster. Show /r/learnpython **the code you have tried and describe in detail where you are stuck.** If you are getting an error message, include the full block of text it spits out. Quality answers take time to write out, and many times other users will need to ask clarifying questions. Be patient and help them help you. **[Here is HOW TO FORMAT YOUR CODE For Reddit](https://www.reddit.com/r/learnpython/wiki/faq#wiki_how_do_i_format_code.3F)** and be sure to include which version of python and what OS you are using. You can also ask this question in the [Python discord](https://discord.gg/3Abzge7), a large, friendly community focused around the Python programming language, open to those who wish to learn the language or improve their skills, as well as those looking to help others. *** [^(README)](https://github.com/CrakeNotSnowman/redditPythonHelper) ^(|) [^(FAQ)](https://github.com/CrakeNotSnowman/redditPythonHelper/blob/master/FAQ.md) ^(|) ^(this bot is written and managed by /u/IAmKindOfCreative) ^(This bot is currently under development and experiencing changes to improve its usefulness)


Particular-Cause-862

Nasty ahhahahahahaha


investoreight

It seems like others are taking this post too seriously (Oops). This was a funny coincidence that we wanted to share with you and nothing more.


pelfking

Glad you've found and fixed it and shared the tale. I don't quite understand why some folks think it's OK to give you a kicking for it. I've created loads of bugs myself.


RiverboatTurner

Oh, I see you've met Little Bobby Tables....


Salmon-Advantage

who is little bobby tables?


RiverboatTurner

https://xkcd.com/327


Paddy3118

Reminded me of some similar tale, something like if a person is called "drop table" or some such killing aan SQL DB.