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

se 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...@gmail.com> wrote: On F

Re: How to put back a number-based index

to make sure it is considered a data column (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

Re: How to put back a number-based index

is considered a data column (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

Re: How to put back a number-based index

is considered a data column (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 Se

Re: How to put back a number-based index

to make sure it is considered a data column (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

Re: How to put back a number-based index

vidg...@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> wrote: I lost my indexes a

Re: How to put back a number-based index

avidg...@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> wrote: I lost my ind

Re: How to put back a number-based index

t; 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> wrote: I lost my indexes after grouping

Re: How to put back a number-based index

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...@gmail.com> wrote: On Fri, May 13,

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

mail.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 in Pandas. I managed to rest_index and got back the index column. But How can I get back a index row? Was the grouping an aggregation? If

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