Any good explanations on pd.merge(df,df2, on=['Code', 'Region'])

I am trying to gain a clear understanding on pd.merge(df,df2, on=['Code', 'Region']). Can anyone assist? Regards, David -- https://mail.python.org/mailman/listinfo/python-list

Can some one give examples of how to use graph.label to get data values while dealing with N-Triples files?

How to used graph.label to get data values like 'Baddesley Clinton E04009816'? "Baddesley Clinton E04009816"@en

How best to search and get values of label in N-Triples

I have a parsed N-Triples file, having many items like the following. "Baddesley Clinton E04009816"@en

Looking for Python examples for querying, selecting items in N-Triples

I found this is very confusing. I will appreciate if simple examples are given. Regards, David -- https://mail.python.org/mailman/listinfo/python-list

Select data in N-Triples

in a N-Triples file, there are a lot lines like the following: "Baginton E04009817"@en .

rdflib, N-Triples and Pandas

How best to use rdflib to parse N-Triples files and turn them into Pandas tables? Looking forward to hearing from you. Regards, David -- https://mail.python.org/mailman/listinfo/python-list

Is there tested Python code for parsing N-Triples?

Is there tested Python code for parsing N-Triples? Looking forward to hearing from you. Regards, David -- https://mail.python.org/mailman/listinfo/python-list

How to make sure the result of Pandas.to_csv does not have non-ASCII code?

How to make sure the result of Pandas.to_csv does not have non-ASCII code? Regards, David -- https://mail.python.org/mailman/listinfo/python-list

Pressing dot and show sub command in IPython

Hi, Matt, How to make IPython work more interactively? As I remember, pressing dot and sub command shows up suggestively in IPython. But, now, after re-installing IPython notebook, it does not do so any more. Looking forward to hearing from you. Regards. David --

How to do pd.read_csv with consecutive spaces or semi-colon as delimiters?

Any way to do that? The link to a sample dataset is as follows: http://www.ebi.ac.uk/ena/data/warehouse/search?query=%22geo_circ(-0.587,-90.5713,170)%22=sequence_release=text Looking forward to hearing from you. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

[no subject]

Which VCF reader has been well tested and proven to be robust? Looking forward to hearing from you. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

[no subject]

13.1. csv — CSV File Reading and Writing — Python 2.7.13 documentation | | | 13.1. csv — CSV File Reading and Writing — Python 2.7.13 documentation | | | I am trying to parse this text file into a table. How to use consecutive 3 spaces to work as delimiter with csv.reader? Looking

Reading structured text file (non-CSV) into Pandas Dataframe

http://www.ebi.ac.uk/ena/data/warehouse/search?query=%22geo_circ(-0.587,-90.5713,170)%22=sequence_release=text The above is a web link to a structured text file.  It is not a CSV. How can this text file be read into a Pandas Dataframe, so that further processing can be made? Looking forward to

Read a text file into a Pandas DataFrame Table

Dear All, Can anyone help to read a text file into a Pandas DataFrame Table? Please see the link below. http://www.ebi.ac.uk/ena/data/warehouse/search?query=%22geo_circ(-0.587,-90.5713,170)%22=sequence_release=text Regards. David -- https://mail.python.org/mailman/listinfo/python-list

How to pd.read_csv into a DataFrame with multiple seperators?

Have a look at this example. http://www.ebi.ac.uk/ena/data/warehouse/search?query=%22geo_circ(-0.587,-90.5713,170)%22=sequence_release=text How to pd.read_csv into a DataFrame with multiple seperators? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

XML tree to a pandas dataframe

What is the best way to convert XML document into a pandas dataframe? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Pound sign problem

In the data set, pound sign escape appears: u'price_currency': u'\xa3', u'price_formatted': u'\xa3525,000', When using table.to_csv after importing pandas as pd, an error message persists as follows: UnicodeEncodeError: 'ascii' codec can't encode character u'\xa3' in position 0: ordinal not in

A Python solution for turning a web page into Pandas DataFrame table

Is there a Python solution for turning a web page into Pandas DataFrame table? Looking forward to hearing from you. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

[no subject]

I was using IPython notebooks.  All the sudden, it asks for password or token. I did not set any password or token. How do I get back to use my IPython notebooks? Looking forward to hearing from you. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Re: How to capture a CSV file and read it into a Pandas Dataframe?

| | | | Is there a way to capture the file? Regards. David On Wednesday, 5 April 2017, 17:19, Skip Montanaro <skip.montan...@gmail.com> wrote: I'm not positive, but try passing response to read_csv() instead of reading the bytes yourself. Skip On Apr 5, 2017 10:38 AM, "David Shi via

How to capture a CSV file and read it into a Pandas Dataframe?

I tried the following codes: import urllib2response = urllib2.urlopen('http://cordis.europa.eu/search/result_en?q=uk=csv')myCSV = response.read() myFile = pd.read_csv(myCSV) but, it did not work well. Can any one help? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

How to make use of .egg files?

Can anyone explain please. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

How to search out all Zip codes and replace with the first 2 digits, in a Pandas dataframe, with the use of regex?

Hi, there, Can anyone help? How to search out all Zip codes and replace with the first 2 digits, in a Pandas dataframe, with the use of regex? For instance, a ZIP code 33132 was found and replaced with 33. Looking forward to hearing from you. Regards. David --

Two constructive reviewers sought

To promote the use of Python and formalise Python approach, I decided to publish a paper. I used geodata as a showcase. Geodata lies in the heart of geographical information science.  The management and processing of such data is of great importance. I got an email from International Journal of

Live installation of Pandas for Windows 64

Is there a live installation of Pandas for Windows 64? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

JSON to Pandas data frame

How to convert a JSON object into a Pandas data frame? I know that for XML, there are XML parsers. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

How to reset IPython notebook file association

I use IPython Notebook to do Python programming. I used "Open with" and set it with Google Chrome.  Then, my IPython notebook does not load properly. How can I reset IPython notebook file association, so that I can use it again? Looking forward to hearing from you. Regards. David --

Which one is the best JSON parser?

Can any one tell me? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Which one is the best XML-parser?

Which one is the best XML-parser? Can any one tell me? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Pandas to CSV and .dbf

Has anyone tested on Pandas to CSV and .dbf lately? I am looking for proven, tested examples to output Panda Data Frame to CSV and dbf files. Looking forward to hearing from you. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Pandas GroupBy does not behave consistently

ol-mean-in-front-of-string-values On Sat, May 14, 2016, 11:40 AM David Shi <davidg...@yahoo.co.uk> wrote: Hello, Michael, Why there is a little u ?  u'ID',? Why can be done to it?  How to handle such objects? Can it be turn into list easily? Regards. David On Saturday, 14 May 2016

Re: How to put back a number-based index

nothing" do you mean it raised an error? What was the error message? Have you tried a Google search for "pandas set index"?http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.set_index.html On Fri, May 13, 2016 at 11:18 PM David Shi <davidg...@yahoo.co.uk> wrote:

Re: How to put back a number-based index

Hello, Michael, This is very weird. 55 145340.20 56 25.43 Name: 3, dtype: float64 It looks like two columns, but it shows one single object. Any clue? On Saturday, 14 May 2016, 4:15, David Shi <davidg...@yahoo.co.uk> wrote: Hello, Mich

Re: How to put back a number-based index

Hello, Michael, I do not understand this. I tried list =df[3] it worked.  But, it does not behave like a list. list[0] nothinglist[1] a valuelist[2] nothing list[4] a value It behaves like a dictionary. On Saturday, 14 May 2016, 4:27, David Shi <davidg...@yahoo.co.uk> wrote:

Re: How to put back a number-based index

Selik <michael.se...@gmail.com> wrote: What have code you tried? What error message are you receiving? On Fri, May 13, 2016, 5:54 PM David Shi <davidg...@yahoo.co.uk> wrote: Hello, Michael, How to convert a float type column into an integer or label or string type? On Friday, 13

Re: How to put back a number-based index

ange(4)}, index=list('abcd'))    >>> df        X    a  0    b  1    c  2    d  3    >>> df.loc['a']    X    0    Name: a, dtype: int64    >>> df.iloc[0]    X    0    Name: a, dtype: int64 On Fri, May 13, 2016 at 4:54 PM David Shi <davidg...@yahoo.co.uk> wrote: Dea

Re: How to put back a number-based index

  y     2    B         z     3 If that doesn't help, you'll need to explain what you're trying to accomplish in detail -- what variables you started with, what transformations you want to do, and what variables you hope to have when finished. On Fri, May 13, 2016 at 4:36 PM David Shi <davidg...@

Re: How to put back a number-based index

',u'WI',u'WV', u'WY'], dtype='object', name=0) How to use this index? Regards. David On Friday, 13 May 2016, 21:19, David Shi <davidg...@yahoo.co.uk> wrote: Hello, Michael, I typed in df.index I got the followingMultiIndex(levels=[[1.0, 4.0, 5.0, 6.0, 8.0, 9.0, 10.0,

Re: How to put back a number-based index

May 2016, 21:11, David Shi <davidg...@yahoo.co.uk> wrote: Dear Michael, I have done a number of operation in between. Providing that information does not help you How to reset index after grouping and various operations is of interest. How to type in a command to find out its current dat

Re: How to put back a number-based index

:29 PM David Shi <davidg...@yahoo.co.uk> wrote: Hello, Michael, Why reset_index before grouping? Regards. David On Friday, 13 May 2016, 17:57, Michael Selik <michael.se...@gmail.com> wrote: On Fri, May 13, 2016 at 12:27 PM David Shi via Python-list <python-list@python.org

Re: How to put back a number-based index

n (via reset_index) and then choose how your aggregation will operate on that column. On Fri, May 13, 2016 at 3:29 PM David Shi <davidg...@yahoo.co.uk> wrote: Hello, Michael, Why reset_index before grouping? Regards. David On Friday, 13 May 2016, 17:57, Michael Selik <michael.se...@g

Re: How to put back a number-based index

Hello, Michael, Why reset_index before grouping? Regards. David On Friday, 13 May 2016, 17:57, Michael Selik <michael.se...@gmail.com> wrote: On Fri, May 13, 2016 at 12:27 PM David Shi via Python-list <python-list@python.org> wrote: I lost my indexes after grouping

Re: How to put back a number-based index

Hello, Michael,Thank you.  Yes, aster grouping I lost my indexing in both x, y directions. How to convert a row, and a column into indexes or labels? On Friday, 13 May 2016, 17:57, Michael Selik <michael.se...@gmail.com> wrote: On Fri, May 13, 2016 at 12:27 PM David Shi via

How to put back a number-based index

I lost my indexes after grouping in Pandas. I managed to rest_index and got back the index column. But How can I get back a index row? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

How to call a Python Class?

I found a Python class within an Open Source software. I would like to use it in my own Python script. I tried to import it, but I got following message. from intersection import *Traceback (most recent call last):  File "", line 1, in     from intersection import *ImportError: bad

How to fill in abbreviation in one column based on state name in another column?

Hello, I am back.  Thank you very much for your positive response. I am trying to use Pandas apply to execute a lookup function, so that we can put abbreviation in a new column, in accordance to a state name in another column. Does anyone knows how to make this to work? Regards.DavidLook up

How to fill in abbreviation in one column based on state name in another column?

I am trying to use apply to execute a lookup function, so that we can put abbreviation in a new column, in accordance to a state name in another column. Does anyone knows how to make this to work? Regards. David state_to_code = {"VERMONT": "VT", "GEORGIA": "GA", "IOWA": "IA", "Armed Forces

Pivot table of Pandas

Hello, Matt, Please see the web link.Pandas Pivot Table Explained |   | |   |   |   |   |   | | Pandas Pivot Table ExplainedExplanation of pandas pivot_table function. | | | | View on pbpython.com | Preview by Yahoo | | | |   | Debra and Fred have their own groups. How to split the pivot

Simplest way to locate a string in a column and get the value on the same row in another column

What is the simplest way to locate a string in a column and get the value on the same row in another column ? 1  a2  b3  c Locate b and obtain 2 in a table. Looking forward to hearing from you. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

ONE CLICK REST API

Eclipse has got one click app for creating REST services. What is it equivalent in Python? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Which plugin allows quick creation of secure REST services?

Hello,  Which plugin allows quick creation of secure REST services?  so that Python scripts can be attached to it. Regards. David -- https://mail.python.org/mailman/listinfo/python-list

IPython and Jupyter

Ipython-4.1.2 I thought that I installed Ipython. I typed in ipython notebook. But a WARNING came up, saying Subcommand 'ipython notebook is deprecated and will be removed in future versions. Then Jupyter turned up. How can I make available both Ipython notebook and Jupyter?, so that I can

Simple, fast responsive, secure way of creating REST services

Hello, Justin, What you said is very interesting and useful. I just wonder whether there are much simpler alternatives for fast, responsive, secure REST services.  Python at server-side.  It provides REST services.  Data exchange with the web--page.  Formatted XML or Json. Ideally, it uses the

Which are best, well-tested ways to create REST services, with Json, in Python?

Has anyone done a recent reviews of creating REST services, in Python? Regards. David -- https://mail.python.org/mailman/listinfo/python-list

Re: Python-list Digest, Vol 108, Issue 98

Hi, Where do I find ArcPy.py? It seems that the link disappeared. Regards. David-- http://mail.python.org/mailman/listinfo/python-list

Looking for download link for ArcPY

Hi, All, Can anyone send me the link for downloading ArcPY? I came across it before, but can not find it anymore. Regards. David-- http://mail.python.org/mailman/listinfo/python-list

Where is the lastest step by step guide to compile Python into an executable?

Hi, folks. Where is the lastest step by step guide to compile Python into an executable? Regards. David -- http://mail.python.org/mailman/listinfo/python-list

Has theHas Python community got Alan Saalfeld et al's algorithm and source code implementation

Dear Python community friends, I wonder whether there is such a Python implementation available. Alan Saalfeld et al's algorithm and source codes. http://books.google.ie/books/about/A_Modified_Douglas_Peucker_Simplificatio.html?id=gbQjywAACAAJredir_esc=y In Zhiyuan Zhao and Alan Saafeld's

Where is the latest step by step guide to use Jython to compile Python into Java?

Hello, Where is the latest step by step guide to use Jython to compile Python into Java? I found that it was very confusing by reading not updated text. Please help. Regards. David -- http://mail.python.org/mailman/listinfo/python-list

Re: Where is the latest step by step guide to use Jython to compilePython into Java?

software or instructions. Please provide assistance, by providing the tested software and instructions. Regards. David From: Narayanaswamy, Mohan mohan.narayanaswam...@sc.com To: David Shi davidg...@yahoo.co.uk Cc: python-list@python.org Sent: Monday, 4

Re: Where is the latest step by step guide to use Jython to compilePython into Java?

: Narayanaswamy, Mohan mohan.narayanaswam...@sc.com To: David Shi davidg...@yahoo.co.uk Cc: python-list@python.org Sent: Monday, 4 June 2012, 16:38 Subject: RE: Where is the latest step by step guide to use Jython to compilePython into Java? David,   Thanks for the link, here that compilation steps

While stack:

Can any one clarify what while stack: mean? Regards, David -- http://mail.python.org/mailman/listinfo/python-list

Looking for Python script for Vector Map simplification, preserving shape and topology

Dear All, I am looking for Python script for Vector Map simplification, preserving shape and topology. Please get in touch with davidg...@yahoo.co.uk    Regards. David -- http://mail.python.org/mailman/listinfo/python-list

How to call and execute C code in Python?

talking about millions of ranges covering years to decades I'd start elsewhere. Emile On Sun, May 13, 2012 at 11:25 PM, David Shi davidg...@yahoo.co.uk wrote: Can anyone tell me how to call and exectute C code in Python? Browse the documentation about Extending and Embedding Python, there's

How to call and execute C code in Python?

Can anyone tell me how to call and exectute C code in Python? Regards. David From: python-list-requ...@python.org python-list-requ...@python.org To: python-list@python.org Sent: Friday, 11 May 2012, 5:35 Subject: Python-list Digest, Vol 104, Issue 57 -

Looking for proven Python code for Line Simplication such as Douglas-Peucker

Dear All, I am looking for  proven Python code for Line Simplication such as Douglas-Peucker. Regards. David -- http://mail.python.org/mailman/listinfo/python-list

Re: Python-list Digest, Vol 102, Issue 64

I am looking very simple and straightforward open source Python REST and SOAP demo modules. I really need things which are very simple and convincing.   I want to demonstrate these to other people. I want to promote you guys' interest.   I find asp and others frustrating and occupy too much

Looking for a simple, generic Python module to provide a secure web service

We are looking for a very simple, generic Python module to provide a secure web service.   Ideally, it can be put onto the computer and make it available via IIS.   Off we go.   Your help will be gratefully received.   Regards.   David-- http://mail.python.org/mailman/listinfo/python-list

Dynamically updating sections of webpage

I want to dynamically update sections of webpage, something like a div or table or frame.   Where can I find best examples/demos for this?  Preferably with a generic loader.   I would also like to find a best book on this.  It needs to be concise, well explained and can be applied universally.  

Looking for an efficient Python script to download and save a .zip file programmatically

I am looking for an efficient Python script to download and save a .zip file programmatically (from http or https call).   Regards.   David -- http://mail.python.org/mailman/listinfo/python-list

Extracting data from XML containing CDATA and store data in a .dbf file

I am looking for advice/efficient script to extract data from XML containing CDATA.   I wish to extract all the data and store it in a .dbf file.   Regards.   David -- http://mail.python.org/mailman/listinfo/python-list

Python calling COM compliant .dll

Hello, there.   I am looking for a concise working example of Python script calling COM compliant .dll.   Regards.   David -- http://mail.python.org/mailman/listinfo/python-list

Has anyone tried calling zip.py in feedback.py and print out an innerHTML to provide a download link?

Hello, there.   Has anyone tried calling zip.py in feedback.py and print out an innerHTML to provide a download link?   I find difficult to make it work.   Sincerely,   David  #** # Description: #Zips the contents of a

Calling Python from Python and .pyc problem

Hello, there.I am using Python 2.5. I used py_compile and made a .pyc file. However, it runs but never stops. What is the best way tocompile a .py file.I am trying to customise the attached script to do the following:calling an external Python script and passing parameters into it.And run

Looking for a nitty-gritty Python Ajax middleware script to fire off a number of processors

Dear All,   I am looking for a nitty-gritty Python Ajax script to fire off a number of processing programmes, periodically checking their operations, sending messages back to an HTML div form by sending back the links of generated data files, to be downloaded by end users.   I am using .NET IIS

.pyc keeps running and never stops

Dear All,   I am using Python 2.5 and used py_compile to produce a .pyc file.  The script runs well.  However, the .pyc keeps running and never stops.   Advices will be deeply appreciated.   Regards.   David -- http://mail.python.org/mailman/listinfo/python-list