title: Sorting Data in Pandas
body: <p>I have the dataset shown below. I am trying to sort it so that the columns are in this order: Week End, Australia, Germany, France, etc...</p>
  <p>I have tried using <code>loc</code> and assigning each of the data sets as variables but when I create a new DataFrame it causes an error. Any help would be appreciated.</p>
  <p>This is the data before any changes:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Region</th>
  <th style="text-align: center;">Week End</th>
  <th style="text-align: right;">Value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">Australia</td>
  <td style="text-align: center;">2014-01-11</td>
  <td style="text-align: right;">1.480510</td>
  </tr>
  <tr>
  <td style="text-align: left;">Germany</td>
  <td style="text-align: center;">2014-01-11</td>
  <td style="text-align: right;">1.481258</td>
  </tr>
  <tr>
  <td style="text-align: left;">France</td>
  <td style="text-align: center;">2014-01-11</td>
  <td style="text-align: right;">0.986507</td>
  </tr>
  <tr>
  <td style="text-align: left;">United Kingdom</td>
  <td style="text-align: center;">2014-01-11</td>
  <td style="text-align: right;">1.973014</td>
  </tr>
  <tr>
  <td style="text-align: left;">Italy</td>
  <td style="text-align: center;">2014-01-11</td>
  <td style="text-align: right;">0.740629</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>This is my desired output:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">Week End</th>
  <th style="text-align: center;">Australia</th>
  <th style="text-align: right;">Germany</th>
  <th style="text-align: right;">France</th>
  <th style="text-align: right;">United Kingdom</th>
  <th style="text-align: right;">Italy</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">2014-01-11</td>
  <td style="text-align: center;">1.480510</td>
  <td style="text-align: right;">1.481258</td>
  <td style="text-align: right;">0.986507</td>
  <td style="text-align: right;">1.973014</td>
  <td style="text-align: right;">0.740629</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>What I've tried:</p>
  <pre><code>cols = (['Region','Week End','Value'])
  df = GS.loc[GS['Brand'].isin(rows)]
  df = df[cols]
  AUS = df.loc[df['Region'] == 'Australia']
  JPN = df.loc[df['Region'] == 'Japan']
  US = df.loc[df['Region'] == 'United States of America']
  </code></pre>