Re: Import Json web data source to xls or csv

Path	csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<hermanmu@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.006
X-Spam-Evidence	'H': 0.99; 'S': 0.00; 'syntax': 0.03; 'importing': 0.04; 'lines.': 0.07; 'suggestions,': 0.07; 'python': 0.09; 'rows': 0.09; 'cc:addr:python-list': 0.10; ':-)': 0.13; 'language': 0.14; '(name': 0.16; 'given)': 0.16; 'libre': 0.16; 'openoffice': 0.16; 'spe': 0.16; 'suggested,': 0.16; 'web?': 0.16; 'wrote:': 0.17; 'windows': 0.19; 'feb': 0.19; 'trying': 0.21; 'fixing': 0.22; 'help.': 0.22; 'cc:20': 0.23; 'programming': 0.23; "haven't": 0.23; 'installed': 0.23; 'seems': 0.23; 'cc:no real name:20': 0.24; 'linux': 0.24; 'tried': 0.25; 'cc:addr:python.org': 0.25; 'header:In-Reply-To:1': 0.25; 'looks': 0.26; 'values': 0.26; 'appreciated.': 0.26; 'thanks!': 0.26; 'done.': 0.27; 'question': 0.27; '(as': 0.27; 'integrate': 0.27; 'message-id:@mail.gmail.com': 0.27; 'received:209.85.212': 0.28; 'exclude': 0.29; 'indentation': 0.29; 'occurred': 0.29; 'questions.': 0.29; 'url:mailman': 0.29; 'probably': 0.29; "i'm": 0.29; 'worked': 0.30; 'error': 0.30; 'figure': 0.30; 'code': 0.31; 'url:python': 0.32; 'quickly': 0.32; 'url:listinfo': 0.32; 'getting': 0.33; 'subject:data': 0.33; 'excel': 0.33; 'received:google.com': 0.34; 'thanks': 0.34; 'compared': 0.35; 'moved': 0.35; 'pm,': 0.35; 'received:209.85': 0.35; 'michael': 0.36; 'but': 0.36; 'url:org': 0.36; "didn't": 0.36; "i'll": 0.36; 'two': 0.37; 'received:209': 0.37; 'subject:: ': 0.38; 'possible.': 0.38; 'where': 0.40; 'help': 0.40; 'url:mail': 0.40; 'your': 0.60; 'office': 0.61; 'love': 0.63; 'box.': 0.65; 'percent': 0.65; 'soon': 0.70; '100': 0.78; '$25': 0.84; '2013': 0.84; 'bid': 0.84; 'softwares': 0.84; 'subject:Import': 0.84; 'subject:source': 0.84; 'to:addr:libero.it': 0.84; 'url:st': 0.84; 'vba': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:cc:content-type; bh=avbqDYmlNAr+ZxbCrAxLsXKC7g6Gx4+iSmiDbzJwerg=; b=rtOFYgv1or+iteP12fmz+jKkb61M7T6uB1z1606J09v96owuBpQGd+E8BrbhwA00Is zYbJ4xSeUdyjM0YjTsoiibWpq90zJfMWOpilP3Rhc1Jj5asDxeUQaDrewRPUvvP23xKx wlhOPqGKtyQw+lgPwFmX5nmP/2M3ZYnTx1onRQOmrV8Ul8fBeVuhKYWjJsgoksfmrcai gyxRsCNEUKKRiqqVin50EEy8MvKIC+gHxAMTqDdkNP3DqD3Cw1PkVi/pRiJhUIMH1f1L 7K0ssnJ1MWnAUqiVe/3sxfPgFZUg4u/KzLCOP8JwfisE74MIa5LTrzReSsfTtWYJ1Br1 u7XA==
X-Received	by 10.52.76.164 with SMTP id l4mr5238536vdw.122.1361384853819; Wed, 20 Feb 2013 10:27:33 -0800 (PST)
MIME-Version	1.0
In-Reply-To	<5124777f$0$40358$4fafbaef@reader1.news.tin.it>
References	<51240f54$0$40361$4fafbaef@reader1.news.tin.it> <mailman.2076.1361325293.2939.python-list@python.org> <5124777f$0$40358$4fafbaef@reader1.news.tin.it>
From	Michael Herman <hermanmu@gmail.com>
Date	Wed, 20 Feb 2013 10:27:13 -0800
Subject	Re: Import Json web data source to xls or csv
To	io <maroso@libero.it>
Content-Type	multipart/alternative; boundary=bcaec50166d39d50b304d62c1ce8
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 <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.2121.1361384862.2939.python-list@python.org> (permalink)
Lines	131
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1361384862 news.xs4all.nl 6875 [2001:888:2000:d::a6]:36343
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:39370

Show key headers only | View raw

[Multipart message — attachments visible in raw view] - view raw

Looks like you got it figured out. The indentation error probably occurred
from the copy and paste job into the email.

If you're interested in getting up to speed quickly on Python and Python
Web Development, I have a kickstarter going - http://kck.st/VQj8hq

The $25 pledge will give you access to both courses - learning Python
syntax and Python web development

Let me know if you have any questions. Thanks!

On Tue, Feb 19, 2013 at 11:13 PM, io <maroso@libero.it> wrote:

> Hi Michael (name of my son) and thanks for the big help.
>
> I'm starting to love python sintax (did they call it python for the slim
> it is compared to other languages?)
>
> Your code didn't work immediatley as it was givin an indentation error
> that i sorted out quickly fixing the last two lines.
>
> It worked like a charm!  :-)
>
> About your suggestions, i tried datanitro but that it only for excel and
> seems to not work under linux on playonlinux (as no linux support is
> given)
>
> I haven't tried the other solution you suggested, i will give it a try as
> soon as possible.
>
> What i'm trying to do is find a new programming language that can
> integrate with softwares like libre office cal or openoffice cal or excel
> as i had my prg working on windows and vba didn't have any issues, but
> now that i moved and try to do all on linux vba isn't 100 percent working
> and many system calls cannot be done.
>
> Do you know any place where i can start learning seriously python on the
> web?
>
>
> Last question : how can i set a condition in order to exclude from
> importing those rows that have both bid and ask values = none?
> I'll try to figure it out in the meantime but i'm a noob so any help will
> be appreciated.
>
> I actually started using SPE and have winpdb installed on my linux box.
>
> Thanks again for all the help.
>
>
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>

Thread

Import Json web data source to xls or csv io <maroso@libero.it> - 2013-02-19 23:48 +0000
  Re: Import Json web data source to xls or csv Michael Herman <hermanmu@gmail.com> - 2013-02-19 17:54 -0800
    Re: Import Json web data source to xls or csv io <maroso@libero.it> - 2013-02-20 07:13 +0000
      Re: Import Json web data source to xls or csv Michael Herman <hermanmu@gmail.com> - 2013-02-20 10:27 -0800
    Re: Import Json web data source to xls or csv rusi <rustompmody@gmail.com> - 2013-02-20 23:29 -0800
      Re: Import Json web data source to xls or csv Peter Otten <__peter__@web.de> - 2013-02-21 09:36 +0100
  Re: Import Json web data source to xls or csv Cousin Stanley <cousinstanley@gmail.com> - 2013-02-20 06:59 +0000
    Re: Import Json web data source to xls or csv io <maroso@libero.it> - 2013-02-20 08:19 +0000
      Re: Import Json web data source to xls or csv pyplexed <julius.welby@gmail.com> - 2013-02-20 02:47 -0800
        Re: Import Json web data source to xls or csv io <maroso@libero.it> - 2013-02-21 00:27 +0000

csiph-web