Saturday, 10 September 2022

Day 102 : Convert CSV to JSON

 

import pandas as pd

import csv,json

data=pd.read_csv("Instagram.csv")

print(data)

print("Converted JSON file below :")

print (json.dumps(list(csv.reader(open('Instagram.csv')))))


#clcoding.com

Impressions  Home  Hashtags  Explore  Other  Saves

0         3920  2586      1028      619     56     98

1         5394  2727      1838     1174     78    194

2         4021  2085      1188        0    533     41

3         4528  2700       621      932     73    172

Converted JSON file below :

[["Impressions", "Home", "Hashtags", "Explore", "Other", "Saves"], ["3920", "2586", "1028", "619", "56", "98"], ["5394", "2727", "1838", "1174", "78", "194"], ["4021", "2085", "1188", "0", "533", "41"], ["4528", "2700", "621", "932", "73", "172"]]

0 Comments:

Post a Comment

Codecademy Code Foundations

Popular Posts

Categories

Android (23) AngularJS (1) Assembly Language (2) Books (10) C (75) C# (12) C++ (81) Course (1) Data Strucures (4) Downloads (1) Engineering (13) flutter (1) FPL (17) Hadoop (1) HTML&CSS (38) IS (25) Java (89) Leet Code (4) Pandas (1) PHP (20) Projects (19) Python (397) R (69) Selenium Webdriver (2) Software (14) SQL (27)