site/docs/3.2.2/api/python/reference/pyspark.pandas/api/pyspark.pandas.DataFrame.to_csv.html - spark-website - Git at Google


 <!DOCTYPE html>

 <html>
   <head>
     <meta charset="utf-8" />
     <title>pyspark.pandas.DataFrame.to_csv &#8212; PySpark 3.2.2 documentation</title>

   <link rel="stylesheet" href="../../../_static/css/index.73d71520a4ca3b99cfee5594769eaaae.css">


   <link rel="stylesheet"
     href="../../../_static/vendor/fontawesome/5.13.0/css/all.min.css">
   <link rel="preload" as="font" type="font/woff2" crossorigin
     href="../../../_static/vendor/fontawesome/5.13.0/webfonts/fa-solid-900.woff2">
   <link rel="preload" as="font" type="font/woff2" crossorigin
     href="../../../_static/vendor/fontawesome/5.13.0/webfonts/fa-brands-400.woff2">


   <link rel="stylesheet"
     href="../../../_static/vendor/open-sans_all/1.44.1/index.css">
   <link rel="stylesheet"
     href="../../../_static/vendor/lato_latin-ext/1.44.1/index.css">


     <link rel="stylesheet" href="../../../_static/basic.css" type="text/css" />
     <link rel="stylesheet" href="../../../_static/pygments.css" type="text/css" />
     <link rel="stylesheet" type="text/css" href="../../../_static/css/pyspark.css" />

   <link rel="preload" as="script" href="../../../_static/js/index.3da636dd464baa7582d2.js">

     <script id="documentation_options" data-url_root="../../../" src="../../../_static/documentation_options.js"></script>
     <script src="../../../_static/jquery.js"></script>
     <script src="../../../_static/underscore.js"></script>
     <script src="../../../_static/doctools.js"></script>
     <script src="../../../_static/language_data.js"></script>
     <script src="../../../_static/copybutton.js"></script>
     <script crossorigin="anonymous" integrity="sha256-Ae2Vz/4ePdIu6ZyI/5ZGsYnb+m0JlOmKPjt6XZ9JJkA=" src="https://cdnjs.cloudflare.com/ajax/libs/require.js/2.3.4/require.min.js"></script>
     <script async="async" src="https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/latest.js?config=TeX-AMS-MML_HTMLorMML"></script>
     <script type="text/x-mathjax-config">MathJax.Hub.Config({"tex2jax": {"inlineMath": [["$", "$"], ["\\(", "\\)"]], "processEscapes": true, "ignoreClass": "document", "processClass": "math|output_area"}})</script>
     <link rel="search" title="Search" href="../../../search.html" />
     <link rel="next" title="pyspark.pandas.read_clipboard" href="pyspark.pandas.read_clipboard.html" />
     <link rel="prev" title="pyspark.pandas.read_csv" href="pyspark.pandas.read_csv.html" />
     <meta name="viewport" content="width=device-width, initial-scale=1" />
     <meta name="docsearch:language" content="en" />
   </head>
   <body data-spy="scroll" data-target="#bd-toc-nav" data-offset="80">

     <nav class="navbar navbar-light navbar-expand-lg bg-light fixed-top bd-navbar" id="navbar-main">
 <div class="container-xl">

     <a class="navbar-brand" href="../../../index.html">

       <img src="../../../_static/spark-logo-reverse.png" class="logo" alt="logo" />

     </a>
     <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbar-menu" aria-controls="navbar-menu" aria-expanded="false" aria-label="Toggle navigation">
         <span class="navbar-toggler-icon"></span>
     </button>

     <div id="navbar-menu" class="col-lg-9 collapse navbar-collapse">
       <ul id="navbar-main-elements" class="navbar-nav mr-auto">


         <li class="nav-item ">
             <a class="nav-link" href="../../../getting_started/index.html">Getting Started</a>
         </li>

         <li class="nav-item ">
             <a class="nav-link" href="../../../user_guide/index.html">User Guide</a>
         </li>

         <li class="nav-item active">
             <a class="nav-link" href="../../index.html">API Reference</a>
         </li>

         <li class="nav-item ">
             <a class="nav-link" href="../../../development/index.html">Development</a>
         </li>

         <li class="nav-item ">
             <a class="nav-link" href="../../../migration_guide/index.html">Migration Guide</a>
         </li>


       </ul>


       <ul class="navbar-nav">


       </ul>
     </div>
 </div>
     </nav>


     <div class="container-xl">
       <div class="row">

           <div class="col-12 col-md-3 bd-sidebar"><form class="bd-search d-flex align-items-center" action="../../../search.html" method="get">
   <i class="icon fas fa-search"></i>
   <input type="search" class="form-control" name="q" id="search-input" placeholder="Search the docs ..." aria-label="Search the docs ..." autocomplete="off" >
 </form>
 <nav class="bd-links" id="bd-docs-nav" aria-label="Main navigation">

     <div class="bd-toc-item active">


     <ul class="nav bd-sidenav">


                 <li class="">
                     <a href="../../pyspark.sql.html">Spark SQL</a>
                 </li>


                 <li class="active">
                     <a href="../index.html">Pandas API on Spark</a>
                     <ul>

                         <li class="active">
                             <a href="../io.html">Input/Output</a>
                         </li>

                         <li class="">
                             <a href="../general_functions.html">General functions</a>
                         </li>

                         <li class="">
                             <a href="../series.html">Series</a>
                         </li>

                         <li class="">
                             <a href="../frame.html">DataFrame</a>
                         </li>

                         <li class="">
                             <a href="../indexing.html">Index objects</a>
                         </li>

                         <li class="">
                             <a href="../window.html">Window</a>
                         </li>

                         <li class="">
                             <a href="../groupby.html">GroupBy</a>
                         </li>

                         <li class="">
                             <a href="../ml.html">Machine Learning utilities</a>
                         </li>

                         <li class="">
                             <a href="../extensions.html">Extensions</a>
                         </li>

                     </ul>
                 </li>


                 <li class="">
                     <a href="../../pyspark.ss.html">Structured Streaming</a>
                 </li>


                 <li class="">
                     <a href="../../pyspark.ml.html">MLlib (DataFrame-based)</a>
                 </li>


                 <li class="">
                     <a href="../../pyspark.streaming.html">Spark Streaming</a>
                 </li>


                 <li class="">
                     <a href="../../pyspark.mllib.html">MLlib (RDD-based)</a>
                 </li>


                 <li class="">
                     <a href="../../pyspark.html">Spark Core</a>
                 </li>


                 <li class="">
                     <a href="../../pyspark.resource.html">Resource Management</a>
                 </li>


       </ul>

   </nav>
           </div>


           <div class="d-none d-xl-block col-xl-2 bd-toc">


 <nav id="bd-toc-nav">
     <ul class="nav section-nav flex-column">

     </ul>
 </nav>


           </div>


           <main class="col-12 col-md-9 col-xl-7 py-md-5 pl-md-5 pr-md-4 bd-content" role="main">

               <div>

   <div class="section" id="pyspark-pandas-dataframe-to-csv">
 <h1>pyspark.pandas.DataFrame.to_csv<a class="headerlink" href="#pyspark-pandas-dataframe-to-csv" title="Permalink to this headline">¶</a></h1>
 <dl class="py method">
 <dt id="pyspark.pandas.DataFrame.to_csv">
 <code class="sig-prename descclassname">DataFrame.</code><code class="sig-name descname">to_csv</code><span class="sig-paren">(</span><em class="sig-param"><span class="n">path</span><span class="p">:</span> <span class="n">Optional<span class="p">[</span>str<span class="p">]</span></span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="n">sep</span><span class="p">:</span> <span class="n">str</span> <span class="o">=</span> <span class="default_value">','</span></em>, <em class="sig-param"><span class="n">na_rep</span><span class="p">:</span> <span class="n">str</span> <span class="o">=</span> <span class="default_value">''</span></em>, <em class="sig-param"><span class="n">columns</span><span class="p">:</span> <span class="n">Optional[List[Union[Any, Tuple[Any, …]]]]</span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="n">header</span><span class="p">:</span> <span class="n">bool</span> <span class="o">=</span> <span class="default_value">True</span></em>, <em class="sig-param"><span class="n">quotechar</span><span class="p">:</span> <span class="n">str</span> <span class="o">=</span> <span class="default_value">'&quot;'</span></em>, <em class="sig-param"><span class="n">date_format</span><span class="p">:</span> <span class="n">Optional<span class="p">[</span>str<span class="p">]</span></span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="n">escapechar</span><span class="p">:</span> <span class="n">Optional<span class="p">[</span>str<span class="p">]</span></span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="n">num_files</span><span class="p">:</span> <span class="n">Optional<span class="p">[</span>int<span class="p">]</span></span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="n">mode</span><span class="p">:</span> <span class="n">str</span> <span class="o">=</span> <span class="default_value">'w'</span></em>, <em class="sig-param"><span class="n">partition_cols</span><span class="p">:</span> <span class="n">Union[str, List[str], None]</span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="n">index_col</span><span class="p">:</span> <span class="n">Union[str, List[str], None]</span> <span class="o">=</span> <span class="default_value">None</span></em>, <em class="sig-param"><span class="o">**</span><span class="n">options</span><span class="p">:</span> <span class="n">Any</span></em><span class="sig-paren">)</span> &#x2192; Optional<span class="p">[</span>str<span class="p">]</span><a class="headerlink" href="#pyspark.pandas.DataFrame.to_csv" title="Permalink to this definition">¶</a></dt>
 <dd><p>Write object to a comma-separated values (csv) file.</p>
 <div class="admonition note">
 <p class="admonition-title">Note</p>
 <p>pandas-on-Spark <cite>to_csv</cite> writes files to a path or URI. Unlike pandas’,
 pandas-on-Spark respects HDFS’s property such as ‘fs.default.name’.</p>
 </div>
 <div class="admonition note">
 <p class="admonition-title">Note</p>
 <p>pandas-on-Spark writes CSV files into the directory, <cite>path</cite>, and writes
 multiple <cite>part-…</cite> files in the directory when <cite>path</cite> is specified.
 This behaviour was inherited from Apache Spark. The number of files can
 be controlled by <cite>num_files</cite>.</p>
 </div>
 <dl class="field-list">
 <dt class="field-odd">Parameters</dt>
 <dd class="field-odd"><dl>
 <dt><strong>path</strong><span class="classifier">str, default None</span></dt><dd><p>File path. If None is provided the result is returned as a string.</p>
 </dd>
 <dt><strong>sep</strong><span class="classifier">str, default ‘,’</span></dt><dd><p>String of length 1. Field delimiter for the output file.</p>
 </dd>
 <dt><strong>na_rep</strong><span class="classifier">str, default ‘’</span></dt><dd><p>Missing data representation.</p>
 </dd>
 <dt><strong>columns</strong><span class="classifier">sequence, optional</span></dt><dd><p>Columns to write.</p>
 </dd>
 <dt><strong>header</strong><span class="classifier">bool or list of str, default True</span></dt><dd><p>Write out the column names. If a list of strings is given it is
 assumed to be aliases for the column names.</p>
 </dd>
 <dt><strong>quotechar</strong><span class="classifier">str, default ‘”’</span></dt><dd><p>String of length 1. Character used to quote fields.</p>
 </dd>
 <dt><strong>date_format</strong><span class="classifier">str, default None</span></dt><dd><p>Format string for datetime objects.</p>
 </dd>
 <dt><strong>escapechar</strong><span class="classifier">str, default None</span></dt><dd><p>String of length 1. Character used to escape <cite>sep</cite> and <cite>quotechar</cite>
 when appropriate.</p>
 </dd>
 <dt><strong>num_files</strong><span class="classifier">the number of files to be written in <cite>path</cite> directory when</span></dt><dd><p>this is a path.</p>
 </dd>
 <dt><strong>mode</strong><span class="classifier">str</span></dt><dd><p>Python write mode, default ‘w’.</p>
 <div class="admonition note">
 <p class="admonition-title">Note</p>
 <p>mode can accept the strings for Spark writing mode.
 Such as ‘append’, ‘overwrite’, ‘ignore’, ‘error’, ‘errorifexists’.</p>
 <ul class="simple">
 <li><p>‘append’ (equivalent to ‘a’): Append the new data to existing data.</p></li>
 <li><p>‘overwrite’ (equivalent to ‘w’): Overwrite existing data.</p></li>
 <li><p>‘ignore’: Silently ignore this operation if data already exists.</p></li>
 <li><p>‘error’ or ‘errorifexists’: Throw an exception if data already exists.</p></li>
 </ul>
 </div>
 </dd>
 <dt><strong>partition_cols</strong><span class="classifier">str or list of str, optional, default None</span></dt><dd><p>Names of partitioning columns</p>
 </dd>
 <dt><strong>index_col: str or list of str, optional, default: None</strong></dt><dd><p>Column names to be used in Spark to represent pandas-on-Spark’s index. The index name
 in pandas-on-Spark is ignored. By default, the index is always lost.</p>
 </dd>
 <dt><strong>options: keyword arguments for additional options specific to PySpark.</strong></dt><dd><p>This kwargs are specific to PySpark’s CSV options to pass. Check
 the options in PySpark’s API documentation for spark.write.csv(…).
 It has higher priority and overwrites all other options.
 This parameter only works when <cite>path</cite> is specified.</p>
 </dd>
 </dl>
 </dd>
 <dt class="field-even">Returns</dt>
 <dd class="field-even"><dl class="simple">
 <dt>str or None</dt><dd></dd>
 </dl>
 </dd>
 </dl>
 <div class="admonition seealso">
 <p class="admonition-title">See also</p>
 <dl class="simple">
 <dt><a class="reference internal" href="pyspark.pandas.read_csv.html#pyspark.pandas.read_csv" title="pyspark.pandas.read_csv"><code class="xref py py-obj docutils literal notranslate"><span class="pre">read_csv</span></code></a></dt><dd></dd>
 <dt><a class="reference internal" href="pyspark.pandas.DataFrame.to_delta.html#pyspark.pandas.DataFrame.to_delta" title="pyspark.pandas.DataFrame.to_delta"><code class="xref py py-obj docutils literal notranslate"><span class="pre">DataFrame.to_delta</span></code></a></dt><dd></dd>
 <dt><a class="reference internal" href="pyspark.pandas.DataFrame.to_table.html#pyspark.pandas.DataFrame.to_table" title="pyspark.pandas.DataFrame.to_table"><code class="xref py py-obj docutils literal notranslate"><span class="pre">DataFrame.to_table</span></code></a></dt><dd></dd>
 <dt><a class="reference internal" href="pyspark.pandas.DataFrame.to_parquet.html#pyspark.pandas.DataFrame.to_parquet" title="pyspark.pandas.DataFrame.to_parquet"><code class="xref py py-obj docutils literal notranslate"><span class="pre">DataFrame.to_parquet</span></code></a></dt><dd></dd>
 <dt><a class="reference internal" href="pyspark.pandas.DataFrame.to_spark_io.html#pyspark.pandas.DataFrame.to_spark_io" title="pyspark.pandas.DataFrame.to_spark_io"><code class="xref py py-obj docutils literal notranslate"><span class="pre">DataFrame.to_spark_io</span></code></a></dt><dd></dd>
 </dl>
 </div>
 <p class="rubric">Examples</p>
 <div class="doctest highlight-default notranslate"><div class="highlight"><pre><span></span><span class="gp">&gt;&gt;&gt; </span><span class="n">df</span> <span class="o">=</span> <span class="n">ps</span><span class="o">.</span><span class="n">DataFrame</span><span class="p">(</span><span class="nb">dict</span><span class="p">(</span>
 <span class="gp">... </span>   <span class="n">date</span><span class="o">=</span><span class="nb">list</span><span class="p">(</span><span class="n">pd</span><span class="o">.</span><span class="n">date_range</span><span class="p">(</span><span class="s1">&#39;2012-1-1 12:00:00&#39;</span><span class="p">,</span> <span class="n">periods</span><span class="o">=</span><span class="mi">3</span><span class="p">,</span> <span class="n">freq</span><span class="o">=</span><span class="s1">&#39;M&#39;</span><span class="p">)),</span>
 <span class="gp">... </span>   <span class="n">country</span><span class="o">=</span><span class="p">[</span><span class="s1">&#39;KR&#39;</span><span class="p">,</span> <span class="s1">&#39;US&#39;</span><span class="p">,</span> <span class="s1">&#39;JP&#39;</span><span class="p">],</span>
 <span class="gp">... </span>   <span class="n">code</span><span class="o">=</span><span class="p">[</span><span class="mi">1</span><span class="p">,</span> <span class="mi">2</span> <span class="p">,</span><span class="mi">3</span><span class="p">]),</span> <span class="n">columns</span><span class="o">=</span><span class="p">[</span><span class="s1">&#39;date&#39;</span><span class="p">,</span> <span class="s1">&#39;country&#39;</span><span class="p">,</span> <span class="s1">&#39;code&#39;</span><span class="p">])</span>
 <span class="gp">&gt;&gt;&gt; </span><span class="n">df</span><span class="o">.</span><span class="n">sort_values</span><span class="p">(</span><span class="n">by</span><span class="o">=</span><span class="s2">&quot;date&quot;</span><span class="p">)</span>
 <span class="go">                   date country  code</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>      <span class="n">KR</span>     <span class="mi">1</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">02</span><span class="o">-</span><span class="mi">29</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>      <span class="n">US</span>     <span class="mi">2</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>      <span class="n">JP</span>     <span class="mi">3</span>
 </pre></div>
 </div>
 <div class="doctest highlight-default notranslate"><div class="highlight"><pre><span></span><span class="gp">&gt;&gt;&gt; </span><span class="nb">print</span><span class="p">(</span><span class="n">df</span><span class="o">.</span><span class="n">to_csv</span><span class="p">())</span>
 <span class="go">date,country,code</span>
 <span class="go">2012-01-31 12:00:00,KR,1</span>
 <span class="go">2012-02-29 12:00:00,US,2</span>
 <span class="go">2012-03-31 12:00:00,JP,3</span>
 </pre></div>
 </div>
 <div class="doctest highlight-default notranslate"><div class="highlight"><pre><span></span><span class="gp">&gt;&gt;&gt; </span><span class="n">df</span><span class="o">.</span><span class="n">cummax</span><span class="p">()</span><span class="o">.</span><span class="n">to_csv</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="sa">r</span><span class="s1">&#39;</span><span class="si">%s</span><span class="s1">/to_csv/foo.csv&#39;</span> <span class="o">%</span> <span class="n">path</span><span class="p">,</span> <span class="n">num_files</span><span class="o">=</span><span class="mi">1</span><span class="p">)</span>
 <span class="gp">&gt;&gt;&gt; </span><span class="n">ps</span><span class="o">.</span><span class="n">read_csv</span><span class="p">(</span>
 <span class="gp">... </span>   <span class="n">path</span><span class="o">=</span><span class="sa">r</span><span class="s1">&#39;</span><span class="si">%s</span><span class="s1">/to_csv/foo.csv&#39;</span> <span class="o">%</span> <span class="n">path</span>
 <span class="gp">... </span><span class="p">)</span><span class="o">.</span><span class="n">sort_values</span><span class="p">(</span><span class="n">by</span><span class="o">=</span><span class="s2">&quot;date&quot;</span><span class="p">)</span>
 <span class="go">                   date country  code</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>      <span class="n">KR</span>     <span class="mi">1</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">02</span><span class="o">-</span><span class="mi">29</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>      <span class="n">US</span>     <span class="mi">2</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>      <span class="n">US</span>     <span class="mi">3</span>
 </pre></div>
 </div>
 <p>In case of Series,</p>
 <div class="doctest highlight-default notranslate"><div class="highlight"><pre><span></span><span class="gp">&gt;&gt;&gt; </span><span class="nb">print</span><span class="p">(</span><span class="n">df</span><span class="o">.</span><span class="n">date</span><span class="o">.</span><span class="n">to_csv</span><span class="p">())</span>
 <span class="go">date</span>
 <span class="go">2012-01-31 12:00:00</span>
 <span class="go">2012-02-29 12:00:00</span>
 <span class="go">2012-03-31 12:00:00</span>
 </pre></div>
 </div>
 <div class="doctest highlight-default notranslate"><div class="highlight"><pre><span></span><span class="gp">&gt;&gt;&gt; </span><span class="n">df</span><span class="o">.</span><span class="n">date</span><span class="o">.</span><span class="n">to_csv</span><span class="p">(</span><span class="n">path</span><span class="o">=</span><span class="sa">r</span><span class="s1">&#39;</span><span class="si">%s</span><span class="s1">/to_csv/foo.csv&#39;</span> <span class="o">%</span> <span class="n">path</span><span class="p">,</span> <span class="n">num_files</span><span class="o">=</span><span class="mi">1</span><span class="p">)</span>
 <span class="gp">&gt;&gt;&gt; </span><span class="n">ps</span><span class="o">.</span><span class="n">read_csv</span><span class="p">(</span>
 <span class="gp">... </span>    <span class="n">path</span><span class="o">=</span><span class="sa">r</span><span class="s1">&#39;</span><span class="si">%s</span><span class="s1">/to_csv/foo.csv&#39;</span> <span class="o">%</span> <span class="n">path</span>
 <span class="gp">... </span><span class="p">)</span><span class="o">.</span><span class="n">sort_values</span><span class="p">(</span><span class="n">by</span><span class="o">=</span><span class="s2">&quot;date&quot;</span><span class="p">)</span>
 <span class="go">                   date</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">02</span><span class="o">-</span><span class="mi">29</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>
 <span class="gp">... </span><span class="mi">2012</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>
 </pre></div>
 </div>
 <p>You can preserve the index in the roundtrip as below.</p>
 <div class="doctest highlight-default notranslate"><div class="highlight"><pre><span></span><span class="gp">&gt;&gt;&gt; </span><span class="n">df</span><span class="o">.</span><span class="n">set_index</span><span class="p">(</span><span class="s2">&quot;country&quot;</span><span class="p">,</span> <span class="n">append</span><span class="o">=</span><span class="kc">True</span><span class="p">,</span> <span class="n">inplace</span><span class="o">=</span><span class="kc">True</span><span class="p">)</span>
 <span class="gp">&gt;&gt;&gt; </span><span class="n">df</span><span class="o">.</span><span class="n">date</span><span class="o">.</span><span class="n">to_csv</span><span class="p">(</span>
 <span class="gp">... </span>    <span class="n">path</span><span class="o">=</span><span class="sa">r</span><span class="s1">&#39;</span><span class="si">%s</span><span class="s1">/to_csv/bar.csv&#39;</span> <span class="o">%</span> <span class="n">path</span><span class="p">,</span>
 <span class="gp">... </span>    <span class="n">num_files</span><span class="o">=</span><span class="mi">1</span><span class="p">,</span>
 <span class="gp">... </span>    <span class="n">index_col</span><span class="o">=</span><span class="p">[</span><span class="s2">&quot;index1&quot;</span><span class="p">,</span> <span class="s2">&quot;index2&quot;</span><span class="p">])</span>
 <span class="gp">&gt;&gt;&gt; </span><span class="n">ps</span><span class="o">.</span><span class="n">read_csv</span><span class="p">(</span>
 <span class="gp">... </span>    <span class="n">path</span><span class="o">=</span><span class="sa">r</span><span class="s1">&#39;</span><span class="si">%s</span><span class="s1">/to_csv/bar.csv&#39;</span> <span class="o">%</span> <span class="n">path</span><span class="p">,</span> <span class="n">index_col</span><span class="o">=</span><span class="p">[</span><span class="s2">&quot;index1&quot;</span><span class="p">,</span> <span class="s2">&quot;index2&quot;</span><span class="p">]</span>
 <span class="gp">... </span><span class="p">)</span><span class="o">.</span><span class="n">sort_values</span><span class="p">(</span><span class="n">by</span><span class="o">=</span><span class="s2">&quot;date&quot;</span><span class="p">)</span>
 <span class="go">                             date</span>
 <span class="go">index1 index2</span>
 <span class="gp">... </span>   <span class="o">...</span>    <span class="mi">2012</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>
 <span class="gp">... </span>   <span class="o">...</span>    <span class="mi">2012</span><span class="o">-</span><span class="mi">02</span><span class="o">-</span><span class="mi">29</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>
 <span class="gp">... </span>   <span class="o">...</span>    <span class="mi">2012</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">31</span> <span class="mi">12</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span>
 </pre></div>
 </div>
 </dd></dl>

 </div>


               </div>


               <div class='prev-next-bottom'>

     <a class='left-prev' id="prev-link" href="pyspark.pandas.read_csv.html" title="previous page">pyspark.pandas.read_csv</a>
     <a class='right-next' id="next-link" href="pyspark.pandas.read_clipboard.html" title="next page">pyspark.pandas.read_clipboard</a>

               </div>

           </main>


       </div>
     </div>


   <script src="../../../_static/js/index.3da636dd464baa7582d2.js"></script>


     <footer class="footer mt-5 mt-md-0">
   <div class="container">
     <p>
           &copy; Copyright .<br/>
         Created using <a href="http://sphinx-doc.org/">Sphinx</a> 3.0.4.<br/>
     </p>
   </div>
 </footer>
   </body>
 </html>