Removing characters from a variable in Python

Question

I've been using the weather site Open Weather Map (https://openweathermap.org/) to get details for a project in Python.

rain = w.get_rain() # Get rain volume {'3h': 0} 
wind = w.get_wind() # Get wind degree and speed {'deg': 59, 'speed': 2.660}
humidity = w.get_humidity() # Get humidity percentage 67

And then insert them the variables into a database, which doesn't like '{' '}'.

I've tried removing the '{' '}' from the outputs, looking at replies from this site. Strip:

rain = rain.strip(['{','}'])

and Replace:

rain = rain.replace('{', ' ')

But all I'm getting are "AttributeError: 'dict' object has no attribute". Is there another escape clause I could use for the variable to remove the unwanted characters?

How to use string.replace() in python 3.x

How to remove certain characters from a variable? (Python)

A python dictionary is returned and you need to call the key and value instead of removing the {}. I'll add an answer that shows how to do this. — tda
– tda, Commented May 3, 2018 at 12:57
There are a few problems here, and it's not clear which on you want to address. You are getting back JSON from the API, so you probably want to use the json module to work with the responses. Further, you should be using your database API to deal with special characters if you really want to store the entire JSON result, not just an extracted value, rather than trying to manually escape things. — chepner
– chepner, Commented May 3, 2018 at 12:57
(Actually, the AttributeError comes from the fact that you do have a dict, not a JSON object, which raises the question of what you mean by the database not liking the braces.) — chepner
– chepner, Commented May 3, 2018 at 12:59

tda · Accepted Answer · 2018-05-03 13:05:17Z

3

A python dictionary is returned and you need to access the key and value instead of removing the {}. The following shows how to access dictionary values.

print(rain.keys()) # returns a list of all dictionary keys
>>> ['3h']

print(rain['3h']) # returns the value associated with the '3h' key
>>> 0

edited May 3, 2018 at 13:05

answered May 3, 2018 at 12:57

tda

2,1431 gold badge21 silver badges44 bronze badges

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

6 Comments

Phil Over a year ago

Thanks, that really helped. I was looking at the {}, rather than what was inside them. While it's worked for all the other keys, '3h' doesn't appear to actually be the key: File "weather.py", line 63, in <module> rain = (rain["3h"]) KeyError: '3h' But thanks for getting me on the right track.

tda Over a year ago

You can run rain.keys() to see what keys are in this dictionary, this may help to see what you can access inside :)

Phil Over a year ago

rain = w.get_rain() # Get rain volume {'3h': 0} >>> print rain.keys() >>> Output : [] >>>> hmm, not very helpful.

tda Over a year ago

Can you print "w.get_rain()" and "type(w.get_rain())"? If the first one returns a dictionary, there should be no reason why the .keys() method returns blank.

Phil Over a year ago

Having Tweeted OWN, they say "In the JSON response the rain value is not provided. If it is measured - it is returned in the API response" So, if it's raining you get a response, it it's not you get {}, which screws up the SQL insert. I'm going to try a couple other things, but it's a not a huge loss to my project not having it for the moment.

|

jspcal · Accepted Answer · 2018-05-03 13:13:47Z

0

Since your variable is a dict, you'll need to create a suitable string representation of it. You can concatenate the keys and values with your own formatting like so:

# a: 1, b: 2, c: 3
myString = ', '.join('{}: {}'.format(k, v) for k,v in myDict.items())

Or modify the default string representation returned by str

# 'a': '1', 'b': '2', 'c': '3'
myString = re.sub('[{}]', '', str(myDict));

edited May 3, 2018 at 13:13

answered May 3, 2018 at 13:07

jspcal

52k7 gold badges76 silver badges79 bronze badges

Comments

Konstantin Kozlenko · Accepted Answer · 2018-05-03 13:21:28Z

0

first of all you need to know what type of data you get:

print (type(obj))

and this is not a string, you can't replace any symbols.

one more. if you get info from site as like json-object, so you don't need replace anything because you can use key for parsing info and, if you need, write to database

answered May 3, 2018 at 13:21

Konstantin Kozlenko

1863 bronze badges

2 Comments

tda Over a year ago

The returned error is "AttributeError: 'dict' object has no attribute" so we know it's a dictionary.

Konstantin Kozlenko Over a year ago

and if this is a dictionary, we can write "if 'rain' in obj: rain = obj['rain'] else: rain = ' ' "

Collectives™ on Stack Overflow

Removing characters from a variable in Python

3 Answers 3

6 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related