Keep running into this issue inserting a bang in a dataframe

Question

Thanks for reading. I'm working with this code right here:

df=client.query(SQL).to_dataframe()
df.insert(0,"bang", '\"!\"', allow_duplicates=True)

When I run it in Google Colabs/Python/Pandas, I get this: """!"""

I really need just one quotation like this: "!".

Let me know if you guys have ever encountered this issue.

Hrm.. try `df.insert(0,"bang", r'\"!\"', allow_duplicates=True)` Reason why this may work... https://stackoverflow.com/q/2081640/6361531 — Scott Boston, Aug 05 '20 at 18:34

score 0 · Answer 1 · answered Aug 05 '20 at 18:37

0

I am not that familiar with pandas, but in somethings like the excel dialect of python's csv package, a specific alternative escape sequence is preferred. Like double-quotes being escaped by another double-quote.

There does already seem to be some questions examining this.

answered Aug 05 '20 at 18:37

Kevin

2,234
2
21
26

Simple resolution: Just use the + Operator to add the strings together. – Dylan Jaramillo Aug 07 '20 at 20:33
@DylanJaramillo, ah, so more like this answer https://stackoverflow.com/a/20027386/3003133 ? – Kevin Aug 09 '20 at 17:34

Keep running into this issue inserting a bang in a dataframe

1 Answers1