title: Pandas Merging 101
body: <ul>
  <li>How can I perform a (<code>INNER</code>| (<code>LEFT</code>|<code>RIGHT</code>|<code>FULL</code>) <code>OUTER</code>) <code>JOIN</code> with pandas?</li>
  <li>How do I add NaNs for missing rows after a merge?</li>
  <li>How do I get rid of NaNs after merging?</li>
  <li>Can I merge on the index?</li>
  <li>How do I merge multiple DataFrames?</li>
  <li>Cross join with pandas</li>
  <li><code>merge</code>? <code>join</code>? <code>concat</code>? <code>update</code>? Who? What? Why?!</li>
  </ul>
  <p>... and more. I've seen these recurring questions asking about various facets of the pandas merge functionality. Most of the information regarding merge and its various use cases today is fragmented across dozens of badly worded, unsearchable posts. The aim here is to collate some of the more important points for posterity.</p>
  <p>This Q&amp;A is meant to be the next installment in a series of helpful user guides on common pandas idioms (see <a href="https://stackoverflow.com/questions/47152691/how-to-pivot-a-dataframe">this post on pivoting</a>, and <a href="https://stackoverflow.com/questions/49620538/what-are-the-levels-keys-and-names-arguments-for-in-pandas-concat-functio">this post on concatenation</a>, which I will be touching on, later).</p>
  <p>Please note that this post is <em>not</em> meant to be a replacement for <a href="https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html" rel="noreferrer">the documentation</a>, so please read that as well! Some of the examples are taken from there.</p>
  <hr />
  <h3>Table of Contents</h3>
  <p><sub>For ease of access.</sub></p>
  <ul>
  <li><p><a href="https://stackoverflow.com/a/53645883/4909087">Merging basics - basic types of joins</a> (read this first)</p>
  </li>
  <li><p><a href="https://stackoverflow.com/a/65167356/4909087">Index-based joins</a></p>
  </li>
  <li><p><a href="https://stackoverflow.com/a/65167327/4909087">Generalizing to multiple DataFrames</a></p>
  </li>
  <li><p><a href="https://stackoverflow.com/a/53699013/4909087">Cross join</a></p>
  </li>
  </ul>