How to convert text file to JSON in python?

Question

I have text files that include this data:

SSID: Wudi, quality: 86%
SSID: Vodafone_ADSL_2018, quality: 92%
SSID: Akram, quality: 43%
SSID: WE_BAE8DF, quality: 31%
SSID: BlzS-b21hcjE5MjE5OTg, quality: 31%
SSID: OPPO A53, quality: 31%
SSID: Vodafone_ADSL_2018, quality: 92%
SSID: WIFI 1, quality: 87%
SSID: , quality: 31%
SSID: pretty angel, quality: 31%
SSID: NETGEAR, quality: 84%
SSID: Akram, quality: 40%
SSID: memo, quality: 85%
SSID: Wudi, quality: 86%
SSID: AndroidAP63FC, quality: 38%

So I want to convert my text file to JSON. I have tried this code:

import json
filename = 'data_quality/quality-2021-11-21_12-10-21.908466.txt'
dict1 = {}
with open(filename) as fh:
    for line in fh:
        command, description = line.strip().split(None, 1)
        dict1[command] = description.strip()

out_file = open("testooo.json", "w")
json.dump(dict1, out_file, indent=4, sort_keys = False)
out_file.close()

but it gives me the file in that format:

{
    "SSID:": "AndroidAP63FC, quality: 38%"
}

but I need the file to be formatted like that: first, delete the "SSID" then it becomes

{
   "AndroidAP63FC, quality": "38%",
   "Wudi, quality": "86%",
   "Vodafone_ADSL_2018, quality:" "92%",
   and so on...
}

Note: I have more than 1000 files so I want to do it with code.

you could try splitting on the colon

Paul H
– Paul H

2021-12-09 18:19:28 +00:00
Commented Dec 9, 2021 at 18:19 — Paul H
– Paul H, Commented Dec 9, 2021 at 18:19

Barmar · Accepted Answer · 2021-12-09 18:23:32Z

3

Use colon as the split() delimiter, then use the 2nd element as the key and third element as the value:

import json
filename = 'data_quality/quality-2021-11-21_12-10-21.908466.txt'
dict1 = {}
with open(filename) as fh:
    for line in fh:
        _, command, description = line.strip().split(':')
        dict1[command.strip()] = description.strip()

with open("testooo.json", "w") as out_file:
    json.dump(dict1, out_file, indent=4, sort_keys = False)

edited Dec 9, 2021 at 18:23

answered Dec 9, 2021 at 18:21

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ehab Reda Over a year ago

Thank you! it works.

yaputra jordi · Accepted Answer · 2021-12-09 18:31:48Z

1

You can use regex to capture groups then rearrange the word.

import json
import re

filename = 'data_quality/quality-2021-11-21_12-10-21.908466.txt'
dict1 = {}
with open(filename) as fh:
    for line in fh:
        name, percent = re.findall("SSID: ([^,]*), quality: (\d+)%", line.strip())[0]
        dict1[f"{name}, quality"] = f"{percent}%"
# ...

answered Dec 9, 2021 at 18:31

yaputra jordi

5333 silver badges8 bronze badges

Comments

Marya · Accepted Answer · 2021-12-09 18:31:13Z

0

import json
filename = 'test.txt'
dict1 = {}
with open(filename) as fh:
    for line in fh:
        line = line.replace('SSID: ','')
        command, description = line.strip().split(None, 1)
        dict1[command] = description.strip()
print(dict1)
out_file = open("testooo.json", "w")
json.dump(dict1, out_file, indent=4, sort_keys = False)
out_file.close()

answered Dec 9, 2021 at 18:31

Marya

1781 silver badge8 bronze badges

2 Comments

Marya Over a year ago

only thing you must do is to add "line = line.replace('SSID: ','')"

André Roggeri Campos Over a year ago

This is the same answer that Barmar provided.

Collectives™ on Stack Overflow

How to convert text file to JSON in python?

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related