Pandas Groupby or Pivot solution for a dataframe

I have a pandas dataframe that looks like the below:

Unnamed: 0 date content replyCount retweetCount likeCount quoteCount place hashtags cashtags coin username verified followersCount friendsCount clean_tweet sentiment new_date
0 0 2021-01-31 23:59:59+00:00 #XEM/#USDT\nDetails and advanced trading tools... 0 0 1 0 NaN ['XEM', 'USDT', 'Google', 'Sheets', 'Add_On', ... NaN Bitcoin scalperSignals False 1091 31 XEM USDT Details and advanced trading tools ar... 1 2021-01-31
1 1 2021-01-31 23:59:57+00:00 @elonmusk is it time to revel the truth about ... 0 1 0 0 NaN ['bitcoin'] NaN Bitcoin ParthmStech False 30 103 is it time to revel the truth about bitcoin in... 0 2021-01-31
2 2 2021-01-31 23:59:55+00:00 @Abdiriz27928036 @GBRLDVS Centric protocol &am... 0 0 2 0 NaN NaN NaN Bitcoin bitcoin_savage False 1092 648 Centric protocol amp a deep understanding of h... -1 2021-01-31
3 3 2021-01-31 23:59:51+00:00 #Investing 65.2% in this optimal #crypto portf... 0 1 2 0 NaN ['Investing', 'crypto', 'cash', 'Bitcoin', 'ri... NaN Bitcoin CryptoWatchBot False 2344 2350 Investing 65 2 in this optimal crypto portfoli... -1 2021-01-31
4 4 2021-01-31 23:59:51+00:00 @ChinUpChubbly @maxkeiser Bro taking silver in... 0 0 0 0 NaN NaN NaN Bitcoin RanvirBal17 False 84 331 Bro taking silver in your hands doesn t make i... 1 2021-01-31
5 5 2021-01-31 23:59:50+00:00 @Bloqport Go home Bitcoin 🏠 0 0 0 0 NaN NaN NaN Bitcoin crypto_fruit False 1250 2708 Go home Bitcoin 0 2021-01-31
6 6 2021-01-31 23:59:45+00:00 #BTC falling wedge update\n\nCurrently consoli... 1 1 8 0 NaN ['BTC', 'Bitcoin'] NaN Bitcoin omzcharts False 5228 55 BTC falling wedge update Currently consolidati... 0 2021-01-31
7 7 2021-01-31 23:59:38+00:00 @postcardraps Try this ans hopefully it helps ... 0 0 1 0 NaN NaN NaN Bitcoin TheSirKit False 584 1284 Try this ans hopefully it helps people Buy bit... 0 2021-01-31
8 8 2021-01-31 23:59:38+00:00 @PartyPrat Bitcoin atm what 1 0 0 0 NaN NaN NaN Bitcoin LordOfTheLeg False 381 667 Bitcoin atm what 0 2021-01-31
9 9 2021-01-31 23:59:36+00:00 @elonmusk .\nIf you are new to #Bitcoin and wa... 1 1 1 0 NaN ['Bitcoin', 'Bitcoin', 'Bitcoin'] NaN Bitcoin bitcoinembassyu False 973 20 If you are new to Bitcoin and want to learn wh... 1 2021-01-31

I'm trying to have a final data frame that has rows as the new_date column, column headers as the coins and the values within the table to be the mean (average) of the sentiment column.

This would essentially give me the average sentiment each day for each of the coins in my dataframe.

Example output:

Bitcoin Etherium dogecoin
2021-01-31 .33 .23 .98
2021-02-01 .43 .84 .33
2021-02-02 -0.23 -0.45 .99
2021-02-03 .43 .13 -.54