df json

• https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_json.html

allowed values are: {‘split’, ‘records’, ‘index’, ‘table’}.

jsondata = pv.to_json(orient="split")

'{"columns":["DUPLICATED_IMAGE","DUPLICATED_LINK","MENU_MAX_LEVEL","NEW_PRODUCT_COUNT","PRICE_DOWN_PRODUCT_COUNT","TOTAL_PRODUCT_COUNT"],"index":["\\uace8\\ub4e0\\uad6c\\uc2a4","\\uad6c\\ucc0c","\\uad6c\\ud638","\\uae4c\\ub974\\ub760\\uc5d0","\\ub4c0\\uc5d8","\\ub760\\uc5b4\\ub9ac","\\ub77c\\ucf54\\uc2a4\\ud14c","\\ub791\\ubc29 \\uceec\\ub809\\uc158","\\ub808\\ub2c8\\ubcf8","\\ub8e8\\uc774 \\ube44\\ud1b5","\\ub974\\ubca0\\uc774\\uc9c0","\\ub9c8\\uc778","\\ub9c8\\uc96c","\\ubaa8\\uc870\\uc5d0\\uc2a4\\ud540","\\ubc1c\\ub80c\\uc2dc\\uc544\\uac00","\\ubc84\\ubc84\\ub9ac","\\ubca0\\ub124\\ud1b5","\\ubcf4\\ube0c","\\ube48\\ud3f4","\\uc0b0\\ub4dc\\ub85c","\\uc0b4\\ubc14\\ud1a0\\ub808 \\ud398\\ub808\\uac00\\ubaa8","\\uc0e4\\ub12c","\\uc140\\ub9b0\\ub290","\\uc26c\\uc988\\ubbf8\\uc2a4","\\uc2a4\\ud29c\\ub514\\uc624 \\ud1b0\\ubcf4\\uc774","\\uc2dc\\uc2a4\\ud15c","\\uc2dc\\uc2ac\\ub9ac","\\uc528\\uc528\\ucf5c\\ub809\\ud2b8","\\uc5d0\\ub974\\uba54\\uc2a4","\\uc624\\uc988\\uc138\\ucee8\\ub4dc","\\uc787\\ubbf8\\uc0e4","\\uc9c0\\ucef7","\\ucf54\\uce58","\\ud074\\ub7fd\\ubaa8\\ub098\\ucf54","\\ud0c0\\uc784","\\ud39c\\ub514","\\ud504\\ub77c\\ub2e4"],"data":[[null,1.0,3.0,0.0,0.0,1048.0],[46.0,0.0,3.0,0.0,0.0,2133.0],[null,0.0,4.0,0.0,0.0,1512.0],[88.0,0.0,2.0,0.0,0.0,1440.0],[null,0.0,3.0,0.0,0.0,775.0],[null,0.0,4.0,0.0,0.0,1443.0],[null,0.0,3.0,0.0,1.0,1642.0],[null,0.0,3.0,0.0,0.0,1569.0],[null,0.0,2.0,0.0,0.0,1459.0],[null,7.0,3.0,10.0,0.0,6657.0],[null,0.0,4.0,0.0,0.0,680.0],[null,0.0,3.0,0.0,0.0,1346.0],[null,0.0,2.0,0.0,0.0,1634.0],[172.0,0.0,3.0,0.0,0.0,1076.0],[null,0.0,3.0,4.0,0.0,935.0],[3.0,0.0,4.0,1.0,0.0,2236.0],[null,0.0,4.0,0.0,0.0,2990.0],[349.0,0.0,3.0,11.0,245.0,3353.0],[null,0.0,4.0,0.0,45.0,5861.0],[null,0.0,2.0,0.0,0.0,1529.0],[null,0.0,3.0,0.0,0.0,807.0],[null,0.0,2.0,0.0,0.0,108.0],[null,0.0,4.0,0.0,0.0,272.0],[null,0.0,2.0,0.0,0.0,1125.0],[21.0,0.0,3.0,7.0,0.0,1905.0],[null,0.0,3.0,0.0,0.0,2182.0],[null,0.0,2.0,0.0,45.0,1442.0],[67.0,0.0,3.0,0.0,0.0,1101.0],[148.0,0.0,3.0,3.0,0.0,240.0],[null,0.0,3.0,0.0,0.0,1361.0],[null,0.0,2.0,0.0,0.0,1285.0],[122.0,0.0,3.0,0.0,0.0,2306.0],[3.0,0.0,3.0,0.0,0.0,754.0],[null,0.0,3.0,0.0,0.0,1300.0],[null,0.0,3.0,0.0,0.0,2441.0],[null,0.0,3.0,0.0,0.0,2308.0],[4.0,0.0,3.0,0.0,0.0,2436.0]]}'

# orient, records
jsondata = pv.to_json(orient="orient")

'[{"DUPLICATED_IMAGE":null,"DUPLICATED_LINK":1.0,"MENU_MAX_LEVEL":3.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":1048.0},{"DUPLICATED_IMAGE":46.0,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":3.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":2133.0},{"DUPLICATED_IMAGE":null,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":4.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":1512.0},{"DUPLICATED_IMAGE":88.0,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":2.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":1440.0},
...]'

jsondata = pv.to_json(orient="table")

'{"schema":{"fields":[{"name":"brand","type":"string"},{"name":"DUPLICATED_IMAGE","type":"number"},{"name":"DUPLICATED_LINK","type":"number"},{"name":"MENU_MAX_LEVEL","type":"number"},{"name":"NEW_PRODUCT_COUNT","type":"number"},{"name":"PRICE_DOWN_PRODUCT_COUNT","type":"number"},{"name":"TOTAL_PRODUCT_COUNT","type":"number"}],"primaryKey":["brand"],"pandas_version":"0.20.0"},"data":[{"brand":"\\uace8\\ub4e0\\uad6c\\uc2a4","DUPLICATED_IMAGE":null,"DUPLICATED_LINK":1.0,"MENU_MAX_LEVEL":3.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":1048.0},{"brand":"\\uad6c\\ucc0c","DUPLICATED_IMAGE":46.0,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":3.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":2133.0},{"brand":"\\uad6c\\ud638","DUPLICATED_IMAGE":null,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":4.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":1512.0},{"brand":"\\uae4c\\ub974\\ub760\\uc5d0","DUPLICATED_IMAGE":88.0,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":2.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT":0.0,"TOTAL_PRODUCT_COUNT":1440.0},{"brand":"\\ub4c0\\uc5d8","DUPLICATED_IMAGE":null,"DUPLICATED_LINK":0.0,"MENU_MAX_LEVEL":3.0,"NEW_PRODUCT_COUNT":0.0,"PRICE_DOWN_PRODUCT_COUNT"