<h4 dir="auto">Code Sample, a copy-pastable example if possible</h4>
<div class="highlight highlight-source-python notranslate position-relative overflow-auto" dir="auto" data-snippet-clipboard-copy-content="# Your code here
"><pre class="notranslate"><span class="pl-c"># Your code here</span></pre></div>
<h4 dir="auto">Problem description</h4>
<p dir="auto">Hello I am new to python pandas and i am having a problem figuring out how i can merge multiple values inside a single cell into a one line.</p>
<p dir="auto">Incorrect:<br>
1644107,"Delete stub zones<br>
map.com<br>
map.net",completed</p>
<p dir="auto">Correct format:<br>
1644107,Delete stub zones map.com map.net,completed</p>
<p dir="auto">[this should explain <strong>why</strong> the current behaviour is a problem and why the expected output is a better solution.]</p>
<p dir="auto"><strong>Note</strong>: We receive a lot of issues on our GitHub tracker, so it is very possible that your issue has been posted before. Please check first before submitting so that we do not have to handle and close duplicates!</p>
<p dir="auto"><strong>Note</strong>: Many problems can be resolved by simply upgrading <code class="notranslate">pandas</code> to the latest version. Before submitting, please check if that solution works for you. If possible, you may want to check if <code class="notranslate">master</code> addresses this issue, but that is not necessary.</p>
<p dir="auto">For documentation-related issues, you can check the latest versions of the docs on <code class="notranslate">master</code> here:</p>
<p dir="auto"><a href="https://pandas-docs.github.io/pandas-docs-travis/" rel="nofollow">https://pandas-docs.github.io/pandas-docs-travis/</a></p>
<p dir="auto">If the issue has not been resolved there, go ahead and file it in the issue tracker.</p>
<h4 dir="auto">Expected Output</h4>
<h4 dir="auto">Output of <code class="notranslate">pd.show_versions()</code></h4>
<details>
<p dir="auto">[paste the output of <code class="notranslate">pd.show_versions()</code> here below this line]</p>
</details>
<p dir="auto">When reading a csv, generated by Microsoft SQL Server management studio in UTF-8 encoding by following line of code:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="df = pd.read_csv(file.csv)"><pre class="notranslate"><code class="notranslate">df = pd.read_csv(file.csv)
</code></pre></div>
<p dir="auto">gives problems when specific data frame columns are addressed.</p>
<p dir="auto">Reading the csv itself doesn't give any problem or warning. And it is possible to view the data frame (showing the proper header names). But when you want to address a specific column by its header name, the following error occurs:</p>
<p dir="auto">KeyError: 'no item named <em>header name</em>'</p>
<p dir="auto">When opening the file with a text editor and saving it in ANSI format, the issue isn't there anymore. This workflow helped to overcome this issue by accident, since I was not aware of any encoding issues at all.</p>
<p dir="auto">It would be a big time saver for a user when he is made aware of possible encoding issues at the moment of reading a file. If a column is shown properly and when you address this column by its name resulting in a KeyError is confusing and not helpful.</p>