Path: csiph.com!usenet.pasdenom.info!news.etla.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.009 X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'string.': 0.05; 'assign': 0.07; 'float': 0.07; 'subject:two': 0.07; 'string': 0.09; 'formatting': 0.09; 'imply': 0.09; 'thus,': 0.09; 'cc:addr:python- list': 0.11; 'assume': 0.14; '>>': 0.16; 'aligned.': 0.16; 'trying': 0.19; "python's": 0.19; '>>>': 0.22; 'preferred': 0.22; 'cc:addr:python.org': 0.22; 'print': 0.22; '>>>': 0.24; '(a)': 0.24; 'cc:2**0': 0.24; 'cc:no real name:2**0': 0.24; 'header:In-Reply-To:1': 0.27; 'function': 0.29; 'needed.': 0.30; 'message-id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'text': 0.33; 'url:python': 0.33; 'but': 0.35; 'received:google.com': 0.35; 'url:listinfo': 0.36; 'method': 0.36; 'url:org': 0.36; 'two': 0.37; 'from:addr:googlemail.com': 0.38; 'skip:& 20': 0.39; 'does': 0.39; 'url:mail': 0.40; 'course': 0.61; 'subject: & ': 0.68; 'default': 0.69; '8bit%:100': 0.72; '\xc2\xa0\xc2\xa0': 0.74; 'br,': 0.84; 'skip:\xe0 20': 0.84; 'sri': 0.84; 'subject:round': 0.84; '9.2': 0.91 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:cc:content-type; bh=WhgWlXVOmeK8MFkpNwv0po0+TiDmUgBKogQhw7tJYlU=; b=inKHIuUtbY/ooivTUbk+8rMLV2T8dJYegnxcoEyR3HyWkuSBUJVFNTQu9w7b4Sjuz+ LXqSYBjTRHp6oqSbTkAjsvRhVFpC1bu0zHwLwP1gEGfK6aeAn7+h9z6uvOSgMCz1imsV WHbNWXucN23S9Kp6TQ5eFeu3JaiOhqd2HtysH0v+6g0XJQgjGAWMVhG2D2ON+iRR10eO xX/QvW/vX1wJaYkcT1ydWI3Qlk+yTldNeIlg6ayG2OHX7HGQy5ynar5ri9GcLOxem3UC pPef/GPcejMI+PCuOH+kKBQ3hyUb7ohrWaylQ8GLDfcm0tMMZhfUVe6nlfyiQENR2HEY MPvg== X-Received: by 10.112.26.106 with SMTP id k10mr2656281lbg.5.1364636646941; Sat, 30 Mar 2013 02:44:06 -0700 (PDT) MIME-Version: 1.0 In-Reply-To: References: <515699DB.8060104@amachu.me> From: Roland Mueller Date: Sat, 30 Mar 2013 11:43:46 +0200 Subject: Re: round off to two decimal & return float To: =?UTF-8?B?4K6G4K6u4K6+4K6a4K+N4K6a4K+B?= Content-Type: multipart/alternative; boundary=bcaec554dbbe96add504d9213ab8 Cc: python-list@python.org X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 156 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1364636655 news.xs4all.nl 6969 [2001:888:2000:d::a6]:56765 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:42333 --bcaec554dbbe96add504d9213ab8 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 2013/3/30 Roland Mueller > Hello, > > 2013/3/30 =E0=AE=86=E0=AE=AE=E0=AE=BE=E0=AE=9A=E0=AF=8D=E0=AE=9A=E0=AF=81= > >> Consider the scenario, >> >> >> a =3D 10 >> >> "{0:.2f}".format(a) >> '10.00' >> >> This returns a string 10.00. But what is the preferred method to retain >> 10.0 (float) as 10.00 (float)? >> >> I assume you have a numeric value a and want to have a float with 2 > decimals. This can be achieved with the function round(): > > Of course the representation of the float having a given number of decimals printed out is always a string. The float format does not imply any formatting and Python's default formatting when a float is printed out is to print as decimals as needed. Thus, using round() fives you a float with maximal two decimals. >>> a =3D 9.2022222 >>> a =3D round(a,2) >>> a 9.2 >>> a =3D 9.2222222 >>> a =3D round(a,2) >>> a 9.22 >>> a =3D 10 > > > >>> type(a) > > > >>> a =3D round(10,2) > > > > >>> type (a) > > > > > > >>> a > > > 10.0 > > BR, > Roland > > >> I am trying to assign the value to a cell of a spreadsheet, using >> python-xlwt. I would like to have 10.00 as the value that is right >> aligned. With text it is left aligned. >> >> -- >> >> Sri Ramadoss M >> >> -- >> http://mail.python.org/mailman/listinfo/python-list >> > > --bcaec554dbbe96add504d9213ab8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+MjAxMy8zLzMwIFJvbGFuZCBNdWVsbGVy IDxzcGFuIGRpcj0ibHRyIj4mbHQ7PGEgaHJlZj0ibWFpbHRvOnJvbGFuZC5lbTAwMDFAZ29vZ2xl bWFpbC5jb20iIHRhcmdldD0iX2JsYW5rIj5yb2xhbmQuZW0wMDAxQGdvb2dsZW1haWwuY29tPC9h PiZndDs8L3NwYW4+PGJyPjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1h cmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDox ZXgiPg0KDQpIZWxsbyw8YnI+PGJyPjxkaXYgY2xhc3M9ImdtYWlsX3F1b3RlIj48ZGl2IGNsYXNz PSJpbSI+MjAxMy8zLzMwIOCuhuCuruCuvuCumuCvjeCumuCvgSA8c3BhbiBkaXI9Imx0ciI+Jmx0 OzxhIGhyZWY9Im1haWx0bzphbWFjaHVAYW1hY2h1Lm1lIiB0YXJnZXQ9Il9ibGFuayI+YW1hY2h1 QGFtYWNodS5tZTwvYT4mZ3Q7PC9zcGFuPjxicj48YmxvY2txdW90ZSBjbGFzcz0iZ21haWxfcXVv dGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhleDtib3JkZXItbGVmdDoxcHggI2NjYyBzb2xpZDtw YWRkaW5nLWxlZnQ6MWV4Ij4NCg0KDQpDb25zaWRlciB0aGUgc2NlbmFyaW8sPGJyPg0KPGJyPg0K Jmd0OyZndDsgYSA9IDEwPGJyPg0KJmd0OyZndDsgJnF1b3Q7ezA6LjJmfSZxdW90Oy5mb3JtYXQo YSk8YnI+DQomIzM5OzEwLjAwJiMzOTs8YnI+DQo8YnI+DQpUaGlzIHJldHVybnMgYSBzdHJpbmcg MTAuMDAuIEJ1dCB3aGF0IGlzIHRoZSBwcmVmZXJyZWQgbWV0aG9kIHRvIHJldGFpbjxicj4NCjEw LjAgKGZsb2F0KSBhcyAxMC4wMCAoZmxvYXQpPzxicj4NCjxicj48L2Jsb2NrcXVvdGU+PC9kaXY+ PGRpdj5JIGFzc3VtZSB5b3UgaGF2ZSBhIG51bWVyaWMgdmFsdWUgYSBhbmQgd2FudCB0byBoYXZl IGEgZmxvYXQgd2l0aCAyIGRlY2ltYWxzLiBUaGlzIGNhbiBiZSBhY2hpZXZlZCB3aXRoIHRoZSBm dW5jdGlvbiByb3VuZCgpOsKgPC9kaXY+PGRpdj48YnI+PC9kaXY+PC9kaXY+PC9ibG9ja3F1b3Rl PjxkaXY+T2YgY291cnNlIHRoZSByZXByZXNlbnRhdGlvbiBvZiB0aGUgZmxvYXQgaGF2aW5nIGEg Z2l2ZW4gbnVtYmVyIG9mIMKgZGVjaW1hbHMgcHJpbnRlZCBvdXQgaXMgYWx3YXlzIGEgc3RyaW5n LiBUaGUgZmxvYXQgZm9ybWF0IGRvZXMgbm90IGltcGx5IGFueSBmb3JtYXR0aW5nIGFuZCBQeXRo b24mIzM5O3MgZGVmYXVsdCBmb3JtYXR0aW5nIHdoZW4gYSBmbG9hdCBpcyBwcmludGVkIG91dCBp cyB0byBwcmludCBhcyBkZWNpbWFscyBhcyBuZWVkZWQuIFRodXMsIHVzaW5nIHJvdW5kKCkgZml2 ZXMgeW91IGEgZmxvYXQgd2l0aCBtYXhpbWFsIHR3byBkZWNpbWFscy48L2Rpdj4NCg0KPGRpdj48 YnI+PC9kaXY+PGRpdj48ZGl2PiZndDsmZ3Q7Jmd0OyBhID0gOS4yMDIyMjIyPC9kaXY+PGRpdj4m Z3Q7Jmd0OyZndDsgYSA9IHJvdW5kKGEsMik8L2Rpdj48ZGl2PiZndDsmZ3Q7Jmd0OyBhPC9kaXY+ PGRpdj45LjI8L2Rpdj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PjxkaXY+Jmd0OyZndDsmZ3Q7 IGEgPSA5LjIyMjIyMjI8L2Rpdj48ZGl2PiZndDsmZ3Q7Jmd0OyBhID0gcm91bmQoYSwyKTwvZGl2 Pg0KDQo8ZGl2PiZndDsmZ3Q7Jmd0OyBhPC9kaXY+PGRpdj45LjIyPC9kaXY+PC9kaXY+PGRpdj48 YnI+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBz dHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGlu Zy1sZWZ0OjFleCI+PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPjxkaXY+PC9kaXY+PGRpdj4mZ3Q7 Jmd0OyZndDsgYSA9IDEwIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPC9kaXY+DQoNCg0KPGRp dj4mZ3Q7Jmd0OyZndDsgdHlwZShhKTwvZGl2PjxkaXY+Jmx0O3R5cGUgJiMzOTtpbnQmIzM5OyZn dDs8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PiZndDsmZ3Q7Jmd0OyBhID0gcm91bmQoMTAsMikg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqDCoDwvZGl2Pg0KDQoNCjxkaXY+PGJyPjwvZGl2PjxkaXY+Jmd0OyZndDsmZ3Q7 IHR5cGUgKGEpIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgPC9kaXY+PGRpdj4NCg0KJmx0O3R5cGUg JiMzOTtmbG9hdCYjMzk7Jmd0OyDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoDwvZGl2Pg0KPGRpdj48ZGl2 PiZndDsmZ3Q7Jmd0OyBhIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKg IMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgIMKgwqA8L2Rpdj48 ZGl2PjEwLjAgwqA8L2Rpdj4NCg0KDQo8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkJSLDwvZGl2 PjxkaXY+Um9sYW5kPC9kaXY+PGRpdiBjbGFzcz0iaW0iPjxkaXY+wqA8L2Rpdj48YmxvY2txdW90 ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46MCAwIDAgLjhleDtib3JkZXItbGVm dDoxcHggI2NjYyBzb2xpZDtwYWRkaW5nLWxlZnQ6MWV4Ij4NCkkgYW0gdHJ5aW5nIHRvIGFzc2ln biB0aGUgdmFsdWUgdG8gYSBjZWxsIG9mIGEgc3ByZWFkc2hlZXQsIHVzaW5nPGJyPg0KcHl0aG9u LXhsd3QuIEkgd291bGQgbGlrZSB0byBoYXZlIDEwLjAwIGFzIHRoZSB2YWx1ZSB0aGF0IGlzIHJp Z2h0PGJyPg0KYWxpZ25lZC4gV2l0aCB0ZXh0IGl0IGlzIGxlZnQgYWxpZ25lZC48YnI+DQo8YnI+ DQotLTxicj4NCjxicj4NClNyaSBSYW1hZG9zcyBNPGJyPg0KPHNwYW4+PGZvbnQgY29sb3I9IiM4 ODg4ODgiPjxicj4NCi0tPGJyPg0KPGEgaHJlZj0iaHR0cDovL21haWwucHl0aG9uLm9yZy9tYWls bWFuL2xpc3RpbmZvL3B5dGhvbi1saXN0IiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL21haWwucHl0 aG9uLm9yZy9tYWlsbWFuL2xpc3RpbmZvL3B5dGhvbi1saXN0PC9hPjxicj4NCjwvZm9udD48L3Nw YW4+PC9ibG9ja3F1b3RlPjwvZGl2PjwvZGl2Pjxicj4NCjwvYmxvY2txdW90ZT48L2Rpdj48YnI+ DQo= --bcaec554dbbe96add504d9213ab8--