title: How to understand my Twitter data frame pivot
body: <p>I am trying to create a heat map of my Twitter activity. I would like to map my activity over a week to see the best days and hours for engagement.</p>
  <p>Here is what I have done so far:</p>
  <ul>
  <li>I have extracted my Twitter in a pandas dataframe</li>
  <li>Created separate columns for the day of the tweet and hour of the
  tweet</li>
  <li>Created a separate column for if the tweet got a retweet or not</li>
  </ul>
  <p>When I run the below code, I get decimal place figures instead of number of retweets.</p>
  <pre><code>pivoted_df = tweets.pivot_table(index='hour_of_tweet', columns='day_of_tweet', values='retweet_count')
  pivoted_df = pivoted_df[['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']]
  pivoted_df = pivoted_df.replace(np.nan,0)
  pivoted_df.style.background_gradient(cmap='Blues')
  </code></pre>
  <p>This is the output:</p>
  <p><img src="https://i.imgur.com/8oPXrsA.png" alt="Image" /></p>
  <p>I also double checked the retweet_counts column using <code>series.value_counts()</code>. The values are whole integers, there are no fractional values.</p>