title: Plotting Julia DataFrame columns that have whitespace in their names with Matplotlib
body: <p>I have <code>DataFrames</code> that have whitespace in their column names, because the CSV files they were generated from had whitespace in the names as well. The <code>DataFrame</code>s were generated with the lines</p>
  <pre><code>csvnames::Array{String,1} = filter(x -&gt; endswith(x, &quot;.csv&quot;), readdir(CSV_DIR))
  dfs::Dict{String, DataFrame} = Dict( csvnames[i] =&gt; CSV.File(CSV_DIR * csvnames[i]) |&gt; DataFrame for i in 1:length(csvnames))
  </code></pre>
  <p>The <code>DataFrame</code>s have column names such as &quot;Tehtävä 1&quot;, but none of the following expressions work when I try to access the column (here <code>ecols</code>  is a dataframe):</p>
  <ol>
  <li><p><code>plot = axes.plot(ecols[Symbol(&quot;Tehtävä 1&quot;)])</code> produces the error <code>TypeError(&quot;float() argument must be a string or a number, not 'PyCall.jlwrap'&quot;)</code></p>
  </li>
  <li><p><code>plot = axes.plot(ecols[:Tehtävä_1])</code> produces the error <code>ERROR: LoadError: ArgumentError: column name :Tehtävä_1 not found in the data frame; existing most similar names are: :Tehtävä 1</code></p>
  </li>
  <li><p><code>plot = axes.plot(ecols[:Tehtävä 1])</code> raises the error <code>ERROR: LoadError: MethodError: no method matching typed_hcat(::DataFrame, ::Symbol, ::Int64)</code></p>
  </li>
  </ol>
  <p>It therefore seems that I have no way of plotting <code>DataFrame</code> columns that have spaces in their names. Printing them works just fine, as the line</p>
  <pre><code>println(ecols[Symbol(&quot;Tehtävä 1&quot;)])
  </code></pre>
  <p>produces and array of floats: <code>[1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0, 1.0]</code>, which it is supposed to. Is Matplotlib just incompatible with <code>DataFrame</code>s with whitespace in their column names and if it is, how could I remove all whitespace from the columns of a Julia <code>DataFrame</code>?</p>
  <h1>EDIT</h1>
  <p>I forgot to mention one very crucial point: the <code>DataFrame</code> contains <code>missing</code> values, which Matplotlib can't comprehend. This was causing error 1. I would still very much like to know if there is a way of getting rid of any whitespace in the table column names, possibly during the construction of the <code>DataFrame</code>.</p>