Article Categories

Selected Reading

Programming Articles

Page 2374 of 2547

How to convert a spreadsheet to Python dictionary?

Python Programming

Samual Sam

Updated on 05-Mar-2020 6K+ Views

The easiest way to convert a spreadsheet to Python dictionary is to use an external library like pandas. This provides very helpful features like to_dict on excel objects. You can use these like −Examplefrom pandas import * xls = ExcelFile('my_file.xls') data = xls.parse(xls.sheet_names[0]) print(data.to_dict())OutputThis will give the output −{'id': 10, 'name': "John"}

How do I serialize a Python dictionary into a string, and then back to a dictionary?

Python Programming

Arjun Thakur

Updated on 05-Mar-2020 1K+ Views

The JSON module is a very reliable library to serialize a Python dictionary into a string, and then back to a dictionary. The dumps function converts the dict to a string. exampleimport json my_dict = { 'foo': 42, 'bar': { 'baz': "Hello", 'poo': 124.2 } } my_json = json.dumps(my_dict) print(my_json)OutputThis will give the output −'{"foo": 42, "bar": {"baz": "Hello", "poo": 124.2}}'The loads function converts the string back to a dict. exampleimport json my_str = '{"foo": 42, "bar": {"baz": "Hello", "poo": 124.2}}' my_dict = json.loads(my_str) print(my_dict['bar']['baz'])OutputThis will give the output −Hello

How do we grep a particular keyword from Python tuple?

Python Programming

Lakshmi Srinivas

Updated on 05-Mar-2020 269 Views

If you have a tuple of strings and you want to search for a particular string, You can use the in operator. exampletpl = ("Hello", "world", "Foo", "bar") print("world" in tpl)OutputThis will give the output −TrueExampleIf you want to check if there is a substring present. You can loop over the tuple and find it using:tpl = ("Hello", "world", "Foo", "bar") for i in tpl: if "orld" in i: print("Found orld in " + i )OutputThis will give the output −Found orld in world

How can I convert a bytes array into JSON format in Python?

Python JSON Programming

Arjun Thakur

Updated on 05-Mar-2020 20K+ Views

You need to decode the bytes object to produce a string. This can be done using the decode function from string class that will accept then encoding you want to decode with. examplemy_str = b"Hello" # b means its a byte string new_str = my_str.decode('utf-8') # Decode using the utf-8 encoding print(new_str)OutputThis will give the outputHelloOnce you have the bytes as a string, you can use the JSON.dumps method to convert the string object to JSON. examplemy_str = b'{"foo": 42}' # b means its a byte string new_str = my_str.decode('utf-8') # Decode using the utf-8 encoding import json d ...

How to assign multiple values to a same variable in Python?

Python Programming

Ankith Reddy

Updated on 05-Mar-2020 1K+ Views

In Python, if you try to do something likea = b = c = [0,3,5] a[0] = 10You'll end up with the same values ina, b, and c: [10, 3, 5]This is because all three variables here point to the same value. If you modify this value, you'll get the change reflected in all names, ie, a,b and c. To create a new object and assign it, you can use the copy module. examplea = [0,3,5] import copy b = copy.deepcopy(a) a[0] = 5 print(a) print(b)OutputThis will give the output −[5,3,5] [0,3,5]