Nov-11-2019, 11:22 AM
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
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