Read your excel using the `xlrd` module and then you can use the `csv` module to create your own csv. 

Install the xlrd module in your command line:

`pip install xlrd`

Python script:

    import xlrd
    import csv

    def csv_from_excel():
        wb = xlrd.open_workbook(&#39;excel.xlsx&#39;)
        sh = wb.sheet_by_name(&#39;Sheet1&#39;)
        your_csv_file = open(&#39;your_csv_file.csv&#39;, &#39;w&#39;)
        wr = csv.writer(your_csv_file, quoting=csv.QUOTE_ALL)

        for rownum in range(sh.nrows):
            wr.writerow(sh.row_values(rownum))

        your_csv_file.close()

    # runs the csv_from_excel function:
    csv_from_excel()







I try to implement google oauth, following the [Google OAuth2ForDevices](https://developers.google.com/accounts/docs/OAuth2ForDevices). 

My App is registered on Google Cloud Console, as native App. When I try to follow the OAuth2ForDevices using Google Chromes - Advanced Rest Client Application, I get the json response with the user_code and verfication_url. Opening the verfication_url and enterering the user_code, leads to the follwoing Error: 

&gt; invalid_client: no support email
&gt; Error 400

I tried this with 2 registred Apps on Google Cloud Console. Both leading to the same error. 

**Anys hints, how to solve this? Do I have to register a `support email` somewhere in google cloud services?**

google oauth error invalid_client no support email

    class StyleClass : public QObject {
    public:
        typedef enum
            {
                STYLE_RADIAL,
                STYLE_ENVELOPE,
                STYLE_FILLED
            }  Style;

        Style m_style;
        //...
    };

The .h file has the above code. **How to access the above enum through QML?**



How to access C++ enum from QML?

I am looking for a python library or any help to convert .XLSX files to .CSV files.

Convert XLSX to CSV correctly using python

<p>I am looking for a python library or any help to convert .XLSX files to .CSV files.</p>


I&#39;d like to make a scatter plot where each point is colored by the spatial density of nearby points.  

I&#39;ve come across a very similar question, which shows an example of this using R:
 
https://stackoverflow.com/q/17093935/2983551

What&#39;s the best way to accomplish something similar in python using matplotlib?

How can I make a scatter plot colored by density in matplotlib?

I have the following code which imports a CSV file.  There are 3 columns and I want to set the first two of them to variables.  When I set the second column to the variable &quot;efficiency&quot; the index column is also tacked on.  How can I get rid of the index column?

    df = pd.DataFrame.from_csv(&#39;Efficiency_Data.csv&#39;, header=0, parse_dates=False)
    energy = df.index
    efficiency = df.Efficiency
    print efficiency

I tried using 

    del df[&#39;index&#39;]

after I set 

    energy = df.index

which I found in another post but that results in &quot;KeyError: &#39;index&#39; &quot;

Removing index column in pandas when reading a csv

Having spent a decent amount of time watching both the [tag:r] and [tag:pandas] tags on SO, the impression that I get is that `pandas` questions are less likely to contain reproducible data. This is something that the R community has been pretty good about encouraging, and thanks to guides like [this](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example), newcomers are able to get some help on putting together these examples. People who are able to read these guides and come back with reproducible data will often have much better luck getting answers to their questions.

How can we create good reproducible examples for `pandas` questions? Simple dataframes can be put together, e.g.:

    import pandas as pd
    df = pd.DataFrame({&#39;user&#39;: [&#39;Bob&#39;, &#39;Jane&#39;, &#39;Alice&#39;], 
                       &#39;income&#39;: [40000, 50000, 42000]})

But many example datasets need more complicated structure, e.g.:

* `datetime` indices or data
* Multiple categorical variables (is there an equivalent to R&#39;s `expand.grid()` function, which produces all possible combinations of some given variables?)
* MultiIndex or Panel data

For datasets that are hard to mock up using a few lines of code, is there an equivalent to R&#39;s `dput()` that allows you to generate copy-pasteable code to regenerate your datastructure?




How to make good reproducible pandas examples

I have a dataframe with 2 index levels:


                             value
    Trial    measurement
        1              0        13
                       1         3
                       2         4
        2              0       NaN
                       1        12
        3              0        34 

Which I want to turn into this:

    Trial    measurement       value
        
        1              0        13
        1              1         3
        1              2         4
        2              0       NaN
        2              1        12
        3              0        34 

How can I best do this?   
           


I need this because I want to aggregate the data [as instructed here][1], but I can&#39;t select my columns like that if they are in use as indices.


  [1]: https://stackoverflow.com/a/20108446/1893275

Turn Pandas Multi-Index into column

I am trying to memcheck a C python extension I am writing, but I&#39;m having trouble setting up valgrind to work with python. I would really appreciate some advice. Just for context, this is Ubuntu 13.10, python 2.7.5+, and valgrind 3.8.1.

As per recommendation from [`Readme.valgrind`](http://svn.python.org/projects/python/trunk/Misc/README.valgrind) I did the following.

1) Downloaded the python source with

    sudo apt-get build-dep python2.7
    apt-get source python2.7

2) Applied the code patch, i.e. &quot;Uncomment Py_USING_MEMORY_DEBUGGER in Objects/obmalloc.c&quot;.

3) Applied the suppression patch, i.e. &quot;Uncomment the lines in Misc/valgrind-python.supp that suppress the warnings for PyObject_Free and PyObject_Realloc&quot;

4) Compiled python with 

    ./configure --prefix=/home/dejan/workspace/python --without-pymalloc
    make -j4 install

Note that I did both 2 and 3, while README.valgrind says to do 2 or 3... more can&#39;t hurt. 

Now, let&#39;s test this on some sample python code in `test.py`

    print &quot;Test&quot;

Let&#39;s run valgrind on python with this script

    valgrind --tool=memcheck --leak-check=full --suppressions=python2.7-2.7.5/Misc/valgrind-python.supp bin/python test.py

Unexpectedly, there is still loads of reports from valgrind, with the first one being (and many more following) 

    ==27944== HEAP SUMMARY:
    ==27944==     in use at exit: 857,932 bytes in 5,144 blocks  
    ==27944==   total heap usage: 22,766 allocs, 17,622 frees, 4,276,934 bytes allocated
    ==27944== 
    ==27944== 38 bytes in 1 blocks are possibly lost in loss record 24 of 1,343
    ==27944==    at 0x4C2A2DB: malloc (in /usr/lib/valgrind/vgpreload_memcheck-amd64-linux.so)
    ==27944==    by 0x46B8DD: PyString_FromString (stringobject.c:143)
    ==27944==    by 0x439631: PyFile_FromFile (fileobject.c:157)
    ==27944==    by 0x4E9B4A: _PySys_Init (sysmodule.c:1383)
    ==27944==    by 0x4E29E9: Py_InitializeEx (pythonrun.c:222)
    ==27944==    by 0x4154B4: Py_Main (main.c:546)
    ==27944==    by 0x577DDE4: (below main) (libc-start.c:260)

Am I doing something wrong? Is there a way to valgrind a python script that doesn&#39;t leak and get clean valgrind output? 

How to use valgrind with python?

I use pandas to write to excel file in the following fashion:
    
    import pandas

    writer = pandas.ExcelWriter(&#39;Masterfile.xlsx&#39;) 

    data_filtered.to_excel(writer, &quot;Main&quot;, cols=[&#39;Diff1&#39;, &#39;Diff2&#39;])

    writer.save()

Masterfile.xlsx already consists of number of different tabs. However, it does not yet contain &quot;Main&quot;.

Pandas correctly writes to &quot;Main&quot; sheet, unfortunately it also deletes all other tabs.


How to write to an existing excel file without overwriting data (using pandas)?

Can you please let me know what are the `.NumberFormat` format options in Excel VBA? As you are fully aware Excel 2010 supports the following types:
                        
![enter image description here][1]

I know that we can set for example Text type as:

    .NumberFormat =&quot;@&quot;

or for number:

    .NumberFormat = &quot;0.00000&quot;

Can you please let me know what are other options for types in VBA?

  [1]: http://i.stack.imgur.com/DDIQB.png

What are .NumberFormat Options In Excel VBA?

I am trying to add an Excel sheet named &quot;Temp&quot; at the end of all existing sheets, but this code is not working:

    Private Sub CreateSheet()
        Dim ws As Worksheet
        ws.Name = &quot;Tempo&quot;
        Set ws = Sheets.Add(After:=Sheets(Sheets.Count))
    End Sub

Can you please let me know why?

How to add a named sheet at the end of all Excel sheets?

I need help on my Excel sheet. How can I declare the following `IF` condition properly?


    if A1 = &quot;n/a&quot; then C1 = B1
    else if A1 != &quot;n/a&quot; or has value(int) then C1 = A1*B1

Using &quot;If cell contains #N/A&quot; as a formula condition.

How do you save output of a MySQL query to a MS Excel sheet?

Even if it&#39;s only possible to store the data in a `.txt` file, it will be okay.

How to save MySQL query output to excel or .txt file?

How do I set the default text for a Tkinter Entry widget in the constructor?  I checked the documentation, but I do not see a something like a `&quot;string=&quot;` option to set in the constructor?

There is a similar answer out there for using tables and lists, but this is for a simple Entry widget.

How to set default text for a Tkinter Entry widget

I have only a single key-value pair in a dictionary. I want to assign key to one variable
and it&#39;s value to another variable. I have tried with below ways but I am getting error for same.
 
    &gt;&gt;&gt; d = {&quot;a&quot;: 1}
    
    &gt;&gt;&gt; d.items()
    [(&#39;a&#39;, 1)]
    
    &gt;&gt;&gt; (k, v) = d.items()
    Traceback (most recent call last):
      File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
    ValueError: need more than 1 value to unpack
    
    &gt;&gt;&gt; (k, v) = list(d.items())
    Traceback (most recent call last):
      File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
    ValueError: need more than 1 value to unpack

I know that we can extract key and value one by one, or by for loop and `iteritems()`, but isn&#39;t there a simple way such that we can assign both in a single statement? 


How to extract dictionary single key-value pair in variables

What is the quickest way to insert a pandas DataFrame into mongodb using `PyMongo`?

**Attempts**

    db.myCollection.insert(df.to_dict())

gave an error 

&gt; `InvalidDocument: documents must have only string keys, the key was
&gt; Timestamp(&#39;2013-11-23 13:31:00&#39;, tz=None)`
&gt; 

---
     db.myCollection.insert(df.to_json())

gave an error 

&gt; `TypeError: &#39;str&#39; object does not support item assignment`
&gt; 

---
     db.myCollection.insert({id: df.to_json()})

gave an error 

`InvalidDocument: documents must have only string a keys, key was &lt;built-in function id&gt;`

---
**df**

	&lt;class &#39;pandas.core.frame.DataFrame&#39;&gt;
	DatetimeIndex: 150 entries, 2013-11-23 13:31:26 to 2013-11-23 13:24:07
	Data columns (total 3 columns):
	amount    150  non-null values
	price     150  non-null values
	tid       150  non-null values
	dtypes: float64(2), int64(1)

Insert a Pandas Dataframe into mongodb using PyMongo

I&#39;m trying to get a pretty print of a dictionary, but I&#39;m having no luck:

    &gt;&gt;&gt; import pprint
    &gt;&gt;&gt; a = {&#39;first&#39;: 123, &#39;second&#39;: 456, &#39;third&#39;: {1:1, 2:2}}
    &gt;&gt;&gt; pprint.pprint(a)
    {&#39;first&#39;: 123, &#39;second&#39;: 456, &#39;third&#39;: {1: 1, 2: 2}}

I wanted the output to be on multiple lines, something like this:

    {&#39;first&#39;: 123,
     &#39;second&#39;: 456,
     &#39;third&#39;: {1: 1,
               2: 2}
    }

Can [`pprint`][1] do this? If not, then which module does it? I&#39;m using [Python 2.7.3][2].


  [1]: https://docs.python.org/2/library/pprint.html
  [2]: https://www.python.org/download/releases/2.7.3/

pprint dictionary on multiple lines

I need the index to start at 1 rather than 0 when writing a Pandas DataFrame to CSV.

Here&#39;s an example:

    In [1]: import pandas as pd

    In [2]: result = pd.DataFrame({&#39;Count&#39;: [83, 19, 20]})

    In [3]: result.to_csv(&#39;result.csv&#39;, index_label=&#39;Event_id&#39;)                               

Which produces the following output:

    In [4]: !cat result.csv
    Event_id,Count
    0,83
    1,19
    2,20

But my desired output is this:

    In [5]: !cat result2.csv
    Event_id,Count
    1,83
    2,19
    3,20

I realize that this could be done by adding a sequence of integers shifted by 1 as a column to my data frame, but I&#39;m new to Pandas and I&#39;m wondering if a cleaner way exists.

start index at 1 for Pandas DataFrame

I wrote a Python script merging two csv files, and now I want to add a header to the final csv. I tried following the suggestions reported [here][1] and I got the following error: `expected string, float found`. What is the most pythonic way to fix this?

Here is the code I am using:

    import csv

    with open(&#39;combined_file.csv&#39;, &#39;w&#39;, newline=&#39;&#39;) as outcsv:
        writer = csv.DictWriter(outcsv, fieldnames = [&quot;Date&quot;, &quot;temperature 1&quot;, &quot;Temperature 2&quot;])
        writer.writeheader()

        with open(&#39;t1.csv&#39;, &#39;r&#39;, newline=&#39;&#39;) as incsv:
            reader = csv.reader(incsv)
            writer.writerows(row + [0.0] for row in reader)

        with open(&#39;t2.csv&#39;, &#39;r&#39;, newline=&#39;&#39;) as incsv:
            reader = csv.reader(incsv)
            writer.writerows(row[:1] + [0.0] + row[1:] for row in reader)


  [1]: https://stackoverflow.com/questions/15907200/how-to-add-a-header-to-a-csv-file-in-python

Pythonically add header to a csv file

I&#39;m trying to import a .csv file using `pandas.read_csv()`, however, I don&#39;t want to import the 2nd row of the data file (the row with index = 1 for 0-indexing).

I can&#39;t see how not to import it because the arguments used with the command seem ambiguous:

From the pandas website: 

&gt; `skiprows` : list-like or integer
&gt; 
&gt; Row numbers to skip (0-indexed) or number of rows to skip (int) at the
&gt; start of the file.&quot;

If I put `skiprows=1` in the arguments, how does it know whether to skip the first row or skip the row with index 1?


Skip rows during csv import pandas

I have some csv text data in a package which I want to read using read_csv. I was doing this by 


    from pkgutil import get_data
    from StringIO import StringIO
    
    data = read_csv(StringIO(get_data(&#39;package.subpackage&#39;, &#39;path/to/data.csv&#39;)))

However, StringIO.StringIO disappears in Python 3, and io.StringIO only accepts Unicode. Is there a simple way to do this?

**Edit**: the following does not appear to work 

    import pandas as pd
    
    import pkgutil
    from io import StringIO
    
    def get_data_file(pkg, path):
        f = StringIO()
        contents = unicode(pkgutil.get_data(&#39;pymc.examples&#39;, &#39;data/wells.dat&#39;))
        f.write(contents)
        return f
    
    wells = get_data_file(&#39;pymc.examples&#39;, &#39;data/wells.dat&#39;)
    
    data = pd.read_csv(wells, delimiter=&#39; &#39;, index_col=&#39;id&#39;,
                       dtype={&#39;switch&#39;: np.int8})

failing with 

      File &quot;/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.py&quot;, line 401, in parser_f
        return _read(filepath_or_buffer, kwds)
      File &quot;/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.py&quot;, line 209, in _read
        parser = TextFileReader(filepath_or_buffer, **kwds)
      File &quot;/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.py&quot;, line 509, in __init__
        self._make_engine(self.engine)
      File &quot;/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.py&quot;, line 611, in _make_engine
        self._engine = CParserWrapper(self.f, **self.options)
      File &quot;/usr/local/lib/python2.7/dist-packages/pandas/io/parsers.py&quot;, line 893, in __init__
        self._reader = _parser.TextReader(src, **kwds)
      File &quot;parser.pyx&quot;, line 441, in pandas._parser.TextReader.__cinit__ (pandas/src/parser.c:3940)
      File &quot;parser.pyx&quot;, line 551, in pandas._parser.TextReader._get_header (pandas/src/parser.c:5096)
    pandas._parser.CParserError: Passed header=0 but only 0 lines in file



pandas.read_csv from string or package data

I&#39;ve CSV file (around 10,000 rows ; each row having 300 columns) stored on LINUX server. 
I want to break this CSV file into 500 CSV files of 20 records each. (Each having same CSV header as present in original CSV) 

Is there any linux command to help this conversion? 

Content Type	Original Author	Original Content on Stackoverflow
Question	geogeek	View Question on Stackoverflow
Solution 1 - Python	Hemant	View Answer on Stackoverflow

Convert XLSX to CSV correctly using python

Python Problem Overview

Python Solutions

Solution 1 - Python

How to access C++ enum from QML?

google oauth error invalid_client no support email

Attributions