Forum Discussion

DemoFour's avatar
DemoFour
Continued Contributor
3 years ago

Error with Text.Trim

Hi people,  I am trying to use a list with Text.Trim to remove punctuation and line breaks, but I am getting an error.  In the Gill Raviv exersize 11-4, he uses Text.Trim and amended the code f...
Need Help
DemoFour's avatar
DemoFour
Continued Contributor
3 years ago

HotChilli 

It is a list 

 

 

= {" ", "~", ",", ".", "..", ". .", "...", "....", ".....", "?", "!", "!!", "!!!", "!!!!", "!!!!!", ", ", (", "), "[", "]", "{", "}", "%", "^", "&", "*", "+", "=", ":", ";", "|", "<", ">", "/", """, """, "\", """", "#(tab)", "#(cr)", "#(lf)"}

 

 

 

Data is just junk twitter data so happy to share. 

 

 

let
    Source = #"20230202 Twitter Data",
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Time", type time}}),
    #"Lowercased Text" = Table.TransformColumns(#"Changed Type",{{"Tweet", Text.Lower, type text}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Lowercased Text",{"Tweet ID", "Tweet"}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Removed Other Columns", "Tweet", Splitter.SplitTextByDelimiter("#(lf)", QuoteStyle.Csv), {"Tweet.1", "Tweet.2", "Tweet.3", "Tweet.4", "Tweet.5", "Tweet.6", "Tweet.7", "Tweet.8", "Tweet.9", "Tweet.10", "Tweet.11", "Tweet.12", "Tweet.13", "Tweet.14", "Tweet.15", "Tweet.16", "Tweet.17", "Tweet.18", "Tweet.19", "Tweet.20"}),
    #"Merged Columns" = Table.CombineColumns(#"Split Column by Delimiter",{"Tweet.1", "Tweet.2", "Tweet.3", "Tweet.4", "Tweet.5", "Tweet.6", "Tweet.7", "Tweet.8", "Tweet.9", "Tweet.10", "Tweet.11", "Tweet.12", "Tweet.13", "Tweet.14", "Tweet.15", "Tweet.16", "Tweet.17", "Tweet.18", "Tweet.19", "Tweet.20"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Single Line Tweet"),
    #"Split Column by Delimiter1" = Table.ExpandListColumn(Table.TransformColumns(#"Merged Columns", {{"Single Line Tweet", Splitter.SplitTextByAnyDelimiter(#"Punctuation and Line Breaks", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Single Line Tweet"),
    #"Filtered Rows" = Table.SelectRows(#"Split Column by Delimiter1", each ([Single Line Tweet] <> "")),
    #"Merged Queries" = Table.FuzzyNestedJoin(#"Filtered Rows", {"Single Line Tweet"}, #"Stop Words", {"Stop Word"}, "Stop Words", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true]),
    #"Expanded Stop Words" = Table.ExpandTableColumn(#"Merged Queries", "Stop Words", {"Stop Word"}, {"Stop Word"})
in
    #"Expanded Stop Words"

 

 

DateTweetStock NameCompany Name
2022-09-29 23:41:16+00:00Mainstream media has done an amazing job at brainwashing people. Today at work, we were asked what companies we believe in ; I said @Tesla because they make the safest cars ; EVERYONE disagreed with me because they heard“they catch on fire ; the batteries cost 20k to replace”TSLATesla, Inc.
2022-09-29 23:24:43+00:00Tesla delivery estimates are at around 364k from the analysts. $tslaTSLATesla, Inc.
2022-09-29 23:18:08+00:003/ Even if I include 63.0M unvested RSUs as of 6/30, additional equity needed for the RSUs is 63.0M x $54.20 = $3.4B. If the deal closed tomorrow at $54.20, Elon would need $2.0B for existing shares plus $3.4B for RSUs, so $5.4B new equity. $twtr $tslaTSLATesla, Inc.
2022-09-29 22:40:07+00:00@RealDanODowd @WholeMarsBlog @Tesla Hahaha why are you still trying to stop Tesla FSD bro! Get your **bleep** together and make something better? Thats how companies work, they competed. Crying big old ass fart clown!TSLATesla, Inc.
2022-09-29 22:27:05+00:00@RealDanODowd @Tesla Stop trying to kill kids, you sad deranged old manTSLATesla, Inc.
2022-09-29 22:25:53+00:00@RealDanODowd @Tesla This is you https://t.co/3Ml1XawSEbTSLATesla, Inc.
2022-09-29 22:24:22+00:00For years @WholeMarsBlog viciously silenced @Tesla critics. Failing to silence me, he desperately lashes out  with childish insults about me, my company, my products - and even my 💩! His fear and impotence spurs me on to ensure that everyone understands Full Self-Driving is💩. https://t.co/lw84VzwW5UTSLATesla, Inc.
2022-09-29 22:23:54+00:00$NIO just because I'm down money doesn't mean this is a bad investment. The whole market, everything sucks right now. 2-5 years from now, I'm confident it will pay off. Long the best $AAPL $AMZN $TSLA $GOOGL $NIOTSLATesla, Inc.
2022-09-29 22:23:28+00:0050 likes for some $SPY $TSLA charts to study!

❤️		TSLATesla, Inc.
2022-09-29 22:15:01+00:00@MrJames__321 @KellyRoofing @TeslaSolar @elonmusk @Tesla The powerwalls themselves are waterproof, but what could be bad is any wiring in the house that could be damaged.TSLATesla, Inc.
2022-09-29 21:58:00+00:00Tomorrow, Tesla, $TSLA, AI day 2 is ongoing.

Unusual Whales is bringing some Tesla experts to discuss what to expect and $TSLA generally.

Join below to prepare before the event at 6:55PM EST:

https://t.co/hObh7OdVs5		TSLATesla, Inc.
2022-09-29 21:33:05+00:00Powerwall FTW! https://t.co/GWAaXXCrYvTSLATesla, Inc.
2022-09-29 21:11:30+00:00$TSLAQ: Tesla’s dead in Europe! Everyone else is passing $TSLA in the EU now in EV unit sales! If you don’t believe us, go to eu-evs and see for yourself!

Me: &lt;goes to eu-evs&gt; 🧐 https://t.co/GAyiZAKF56		TSLATesla, Inc.
2022-09-29 21:00:25+00:00The irony is so thick you can cut it with a knife. @Tesla https://t.co/8CihPdpns7TSLATesla, Inc.
2022-09-29 20:15:41+00:00Tesla AI day in 24 hours. Are you ready? $TSLA rocks big time. https://t.co/GxtdO2utB4TSLATesla, Inc.
2022-09-29 19:38:29+00:00Picked up some $TSLA shares at $269 https://t.co/4UQVchSs2RTSLATesla, Inc.
2022-09-29 19:36:59+00:002/ Even if @elonmusk loses the $TWTR trial (would more likely settle at $51-$52/share), Elon would only have to raise $2-$3B more from $TSLA sales (raised $15B equity) to fund the equity needed to complete the deal, assuming the $7B 3P equity and $13B debt financing still intact. https://t.co/PqtHF2sSmJTSLATesla, Inc.
2022-09-29 19:27:54+00:00Everyone should keep a long term perspective. It’s always darkest before the dawn. With 2026 EPS of $20.80, at 40x P/E (2x PEG), $TSLA worth $832 by 2026. Discounting this back at 13.6% (4.0% 10yrTY, 6% ERP, 1.6x beta), $TSLA value $550. That’s 100% upside over 6-12 mos. https://t.co/oPn2JMXBrhTSLATesla, Inc.
2022-09-29 19:24:50+00:00$TSLA Cybertruck can act as a boat according to Elon. https://t.co/aahIkZwUCTTSLATesla, Inc.

 

Garcia16's avatar
Garcia16
Advocate II
3 years ago

Thank you.