Python Forum
Handling escape charters while converting data frame to JSON
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Handling escape charters while converting data frame to JSON
#1
Hi All,
I am new to the python programming so please bear with me if question seems to basic.

i have created url column in my dataframe

df['url'] = r"https://apps.occ.gov/EASearch/?Search=&Category=&ItemsPerPage=10&Sort=&AutoCompleteSelection="

df.head(5)

otherinfo entity ... dob url
0 ... https://apps.occ.gov/EASearch/?Search=&Categor...
1 ... https://apps.occ.gov/EASearch/?Search=&Categor...
2 ... https://apps.occ.gov/EASearch/?Search=&Categor...
3 ... https://apps.occ.gov/EASearch/?Search=&Categor...
4 ... https://apps.occ.gov/EASearch/?Search=&Categor...

but when i am converting my dataframe to json

df.to_json (r'filepath', orient='records')

In the create json, i am getting :

"url":"https:\/\/apps.occ.gov\/EASearch\/?Search=&Category=&ItemsPerPage=10&Sort=&AutoCompleteSelection="

How do i fix this
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Grouping in pandas/multi-index data frame Aleqsie 3 669 Jan-06-2024, 03:55 PM
Last Post: deanhystad
  Filtering Data Frame, with another value NewBiee 9 1,399 Aug-21-2023, 10:53 AM
Last Post: NewBiee
  Exporting data frame to excel dyerlee91 0 1,631 Oct-05-2021, 11:34 AM
Last Post: dyerlee91
  Pandas Data frame column condition check based on length of the value aditi06 1 2,695 Jul-28-2021, 11:08 AM
Last Post: jefsummers
  Adding a new column to a Panda Data Frame rsherry8 2 2,123 Jun-06-2021, 06:49 PM
Last Post: jefsummers
  grouped data frame glitter 0 1,598 Feb-02-2021, 11:22 AM
Last Post: glitter
  how to filter data frame dynamically with the columns psahay 0 2,405 Aug-24-2020, 01:10 PM
Last Post: psahay
  how to handling time series data file with Python? aupres 4 2,990 Aug-10-2020, 12:40 PM
Last Post: MattKahn13
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,222 Aug-03-2020, 02:05 AM
Last Post: scidam
  How to shift data frame rows of specified column Mekala 0 1,902 Jul-21-2020, 02:42 PM
Last Post: Mekala

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020