title: Guidance on joining 2 dataframes, such that each row of df2 becomes an entire column of df1, iterated over all rows of df2
body: <p>I need to 'multiply' two df's together to create all possible solutions, to use in a Tableau scenario. </p>
  
  <p>The scenario is as follows: </p>
  
  <p>I have a df1 of cars and their associated MPGs, and a df2 of zipcodes, and their associated distance from a fixed point (calculating carbon footprint). Once I get the df3 created I can do more math over the entire df to get to my final metric. </p>
  
  <p>I tried my best below to represent a sample of each df, and the resulting df3 that I am looking to create. df1 is 15,000 rows, and df2 is 535 rows, meaning df3 will have 8m rows. </p>
  
  <p>There may be a better way to do this in tableau; however, I am more comfortable in R.   </p>
  
  <p>DF1</p>
  
  <pre><code>mpg|year|make |model
  --------------------
   21|1985|dodge|charger
   19|1993|Audi |100
  
  </code></pre>
  
  <p>DF2</p>
  
  <pre><code>zipcode|distace
  ---------------
   20015 | 8.91
   20020 | 12.72
  </code></pre>
  
  <p>DF3</p>
  
  <pre><code>mpg|year|make |model  |zipcode|distance
  -----------------------------------------
   21|1985|dodge|charger| 20015 |8.91 
   19|1993|Audi |100    | 20015 |8.91
   21|1985|dodge|charger| 20020 |12.72
   19|1993|Audi |100    | 20020 |12.72
  
  
  
  </code></pre>