<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial",sans-serif;
color:#3B3838;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">Hi –
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">I seem to be stuck here trying to convert downloaded data that is in tabular form since I need to analyze it in single column format. The data is from here and I’m
using read_csv as shown below – <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">pnadata1= pd.read_csv('https://www.esrl.noaa.gov/psd/data/correlation/pna.data')<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">The downloaded data looks like this with the values in months 1-12 across the columns below for each year 1948-present –
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"> 1948 2020<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">0 1948 -99.90 -99.90 -99.90 -99.90 -99.90 -99.9...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">1 1949 -99.90 -99.90 -99.90 -99.90 -99.90 -99.9...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">2 1950 -3.65 -1.69 -0.06 -0.23 -0.40 -1.9...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">3 1951 -1.18 -2.11 -1.09 0.47 1.19 -0.5...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">4 1952 -3.19 0.08 -0.69 0.89 -0.79 0.5...<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838">And, I need it to be reshaped to look like this in yyyymm values format so I can compare it easily to other downloaded data in the column format –
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">194801 -99.90<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">194802 -99.90<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">194803 -99.90<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">...<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">202001 -3.45<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">202002 0.87<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in"><o:p> </o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">I’ve tried working with “melt” and “group” in different combinations but cannot figure it
out given the online references. Thank you,<o:p></o:p></span></p>
<p class="MsoNormal" style="vertical-align:baseline"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729;border:none windowtext 1.0pt;padding:0in">Randall</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#242729"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#3B3838"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left">
<tbody>
<tr style="height:102.0pt">
<td colspan="2" style="padding:.75pt .75pt .75pt .75pt;height:102.0pt">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="color:#3B3838"><img width="189" height="114" style="width:1.9687in;height:1.1875in" id="Picture_x0020_1" src="cid:image001.jpg@01D601ED.4AABD360" alt="Description: cid:image001.jpg@01D34737.23261CB0"></span><span style="font-size:12.0pt;color:#3B3838"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt 20.25pt">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#5C881A">Randall P. Benson, PhD</span></b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#5C881A">
<br>
Wind Asset Meteorologist, Energy Resource - Onshore<br>
<br>
1125 NW Couch Street, Suite 700<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#5C881A">Portland, Oregon, USA 97209
<br>
Telephone 503-796-7129<br>
Cell 971-227-2477 <br>
<a href="mailto:randall.benson@avangrid.com"><span style="color:blue">randall.benson@avangrid.com</span></a>
<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:27.0pt">
<td width="95" style="width:45.0pt;padding:.75pt .75pt .75pt 20.25pt;height:27.0pt">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="color:#3B3838"><br>
<img border="0" width="67" height="26" style="width:.6979in;height:.2708in" id="Picture_x0020_2" src="cid:image002.png@01D601ED.4AABD360" alt="Description: cid:image002.png@01D34737.23261CB0"></span><span style="font-size:12.0pt;color:#3B3838"><o:p></o:p></span></p>
</td>
<td width="260" style="width:195.0pt;padding:.75pt .75pt .75pt 4.5pt;height:27.0pt">
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#5C881A"><br>
In the interest of the environment, <br>
please print only if necessary and recycle. <o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#3B3838"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
<table><tr><td bgcolor=#ffffff><font color=#000000><pre>==============================================================
Please consider the environment before printing this email.
If you have received this message in error, please notify the sender and immediately delete this message and any attachment hereto and/or copy hereof, as such message contains confidential information intended solely for the individual or entity to whom it is addressed. The use or disclosure of such information to third parties is prohibited by law and may give rise to civil or criminal liability.
The views presented in this message are solely those of the author(s) and do not necessarily represent the opinion of Avangrid Renewables, LLC. or any company of its group. Neither Avangrid Renewables, LLC. nor any company of its group guarantees the integrity, security or proper receipt of this message. Likewise, neither Avangrid Renewables, LLC. nor any company of its group accepts any liability whatsoever for any possible damages arising from, or in connection with, data interception, software viruses or manipulation by third parties.
==============================================================</pre></font></td></tr></table>