pyspark dataframe cheat sheet

0000151537 00000 n I couldn’t find a halfway decent cheat sheet except for the one here on Datacamp, but I thought it needs an update and needs to be just a bit more extensive than a one-pager. #creating … 0000005880 00000 n # See the License for the specific language governing permissions and # limitations under the License. 0000046906 00000 n 0000074045 00000 n Analytics cookies. sql import functions as F: #SparkContext available as sc, HiveContext available as sqlContext. 0000013183 00000 n 0000038264 00000 n Since RDD is more OOP and functional structure, it is not very friendly to the people like SQL, pandas or R. ... PySpark Cheat Sheet: Spark … # put the df in cache and results will be cached too (try to run a count twice after this), # adding columns and keeping existing ones F.lit(0) return a column, # selecting columns, and creating new ones, # most of the time it's sufficient to just use the column name, # in other cases the col method is nice for referring to columnswithout having to repeat the dataframe name, # grouping and aggregating (first row or last row or sum in the group), #grouping and sorting (count is the name of the created column), ######################################### Date time manipulation ################################, # Casting to timestamp from string with format 2015-01-01 23:59:59. 0000006331 00000 n 0000145523 00000 n 0000151958 00000 n 0000030425 00000 n 0000029500 00000 n Spark SQL was first released in May 2014 and is perhaps now one of the most actively developed components in Spark. Databricks would like to give a special thanks to Jeff Thomspon for contributing 67 visual diagrams depicting the Spark API under the MIT license to the Spark 0000133549 00000 n In my application, this leads to memory issues when scaling up. Learn more. 0000047030 00000 n 0000003116 00000 n >>> from pyspark.sql importSparkSession >>> spark = SparkSession\ Select columns in Pyspark Dataframe, Try something like this: df.select([c for c in df.columns if c in ['_2','_4','_5']]).show(). 0000045438 00000 n # A simple cheat sheet of Spark Dataframe syntax # Current for Spark 1.6.1 # import statements: #from pyspark.sql import SQLContext: #from pyspark.sql.types import * #from pyspark.sql.functions import * from pyspark. 0000149019 00000 n As well as deep learning libraries are difficult to understand. This Spark and RDD cheat sheet is designed for the one who has already started learning about memory management and using Spark as a tool. Code 1: Reading Excel pdf = pd.read_excel(Name.xlsx) sparkDF = sqlContext.createDataFrame(pdf) df = sparkDF.rdd.map(list) type(df) Want to implement without pandas module. 689 0 obj <> endobj xref 689 141 0000000016 00000 n 0000026851 00000 n Use SQL to Query Data in the Data Lake. 0000148676 00000 n 0000100180 00000 n 0000099271 00000 n 0000073431 00000 n 0000090921 00000 n If yes, then you must take PySpark SQL into consideration. pyspark.sql.SparkSession Main entry point for DataFrame and SQL functionality. First, it may be a good idea to bookmark this page, which will be easy to search with Ctrl+F when you're looking for something specific. In the first part of this series, we looked at advances in leveraging the power of relational databases "at scale" using Apache Spark SQL and DataFrames.. We will now do a simple tutorial based on a real-world dataset to look at how to use Spark SQL. pyspark.sql.GroupedData Aggregation methods, returned by DataFrame… 0000152036 00000 n 0000031105 00000 n However, we've also created a PDF version of this cheat sheet that you can download from herein case you'd like to print it out. Spark SQL, then, is a module of PySpark that allows you to work with structured data in the form of DataFrames. Learn more, Cheat sheet for Spark Dataframes (using Python). [PDF] Cheat sheet PySpark SQL Python.indd, from pyspark.sql import functions as F. Select. So, imagine that a small table of 1,000 customers combined with a product table of 1,000 records will produce 1,000,0… Howe… For more information, see our Privacy Statement. 0000089810 00000 n PySpark Cheat Sheet. 0000038776 00000 n trailer <]/Prev 680631/XRefStm 3565>> startxref 0 %%EOF 829 0 obj <>stream Apache Spark is definitely the most active open source proje… # A simple cheat sheet of Spark Dataframe syntax. 0000046426 00000 n 0000045033 00000 n 0000147337 00000 n When we implement spark, there are two ways to manipulate data: RDD and Dataframe. 0000026668 00000 n 0000045558 00000 n 0000146156 00000 n �#\с H�:��A��mcC ��j�0�gZ�V��Ц��8��J�T>;� 6��ltknbXØ��@�[�\�^� C��b��M�R|0h*��fHd8�p�q�~w>�H�C�!L'��$��'p�:��A��%Ȅy��\�4bSc��`>�$!��K��t�~O�R Υa �X\v�ag`K�g�l�aHcy�8Cx[��{"k�r�_d,�ڶ�;)�bpc�8��큘��i�{ ��8��+�2�e��i�ňIfn��/@� mSiB endstream endobj 828 0 obj <>/Filter/FlateDecode/Index[14 675]/Length 45/Size 689/Type/XRef/W[1 1 1]>>stream 0000148598 00000 n 0000007718 00000 n [PDF] Cheat sheet PySpark SQL Python.indd, PySpark filter() function is used to filter the rows from DataFrame or Dataset struct columns using single and multiple conditions with PySpark between is used to check if the value is between two values, the input is a lower bound and an upper bound. 0000085819 00000 n This PySpark SQL cheat sheet is designed for those who have already started learning about and using Spark and PySpark SQL. Learn data science with our online and interactive tutorials. 0000019092 00000 n pyspark.sql.DataFrame A distributed collection of data grouped into named columns. 0000045157 00000 n 0000026734 00000 n This PySpark cheat sheet covers the basics, from initializing Spark and loading your data, to retrieving RDD information, sorting, filtering and sampling your data. 0000146998 00000 n 0000105083 00000 n … We use essential cookies to perform essential website functions, e.g. Below are the steps to create pyspark dataframe Create sparksession. Clone with Git or checkout with SVN using the repository’s web address. 0000046074 00000 n It can not be used to check if a … 0000104845 00000 n 0000046019 00000 n they're used to log you in. If yes, then you must take Spark into your consideration. 0000148177 00000 n ��iMz1�=e!��]g)��E=kƶ��9��-��u�!V��}V��_�g}H�|y�8�r�rt�â�C��w��l��R9=N��u_zf��ݯ�U=+�:p�. 0000095745 00000 n 0000149097 00000 n 0000005173 00000 n Whatever your testing needs … It appears that when I call cache on my dataframe a second time, a new copy is cached to memory. 0000021535 00000 n 0000146078 00000 n 0000046666 00000 n 0000152380 00000 n We use optional third-party analytics cookies to understand how you use GitHub.com so we can build better products. PySpark is the Spark Python API exposes the Spark programming model to Python. 0000026633 00000 n 0000007138 00000 n >>> df.select("firstName").show(). 0000095145 00000 n 0000146499 00000 n 0000010023 00000 n Below are the cheat sheets of PySpark Data Frame and RDD created by DataCamp. 0000038698 00000 n Can someone tell me how to convert a list containing strings to a Dataframe in pyspark. 0000007579 00000 n 0000153305 00000 n 0000149519 00000 n Are you a programmer looking for a powerful tool to work on Spark? Check out this cheat sheet to see some of the different dataframe operations you can use to view and transform your data. spark = SparkSession.builder.appName('SparkByExamples.com').getOrCreate() Create data and columns. 0000003565 00000 n 0000017128 00000 n You'll also see that topics such as repartitioning, iterating, merging, saving your data and stopping the SparkContext are included in the cheat sheet. These snippets are licensed under the CC0 1.0 Universal License. In the previous section, we used PySpark to bring data from the data lake into a dataframe to view and operate on it. This sheet will be a handy reference for them. ؀��c Instantly share code, notes, and snippets. Everything in here is fully functional PySpark code you can run or adapt to your programs. 0000091340 00000 n 0000174706 00000 n 0000026149 00000 n 0000005698 00000 n Learning machine learning and deep learning is difficult for newbies. Spark dataframe alias as you rename pyspark dataframe column methods and examples eek com spark dataframe alias as you spark sql case when on dataframe examples eek com. 0000147757 00000 n 0000146920 00000 n GlobalSQA is one-stop solution to all your QA needs. 0000147415 00000 n 0000021101 00000 n This stands in contrast to RDDs, which are typically used to work with unstructured data. 0000038342 00000 n Creating DataFrames PySpark & Spark SQL. '�Jʭ�D+E�u�L��J�Bf��[��x��W��/��Xrvv~1 ��pd��ƍĻ�οsC�f�HNG�wowt��WIF�� g�]�#�2g�VSf>�'��_.�e_1�[��E��a��d�-&}�I/��w�K�q�|��:��ףQ��U8�$$C9�p�G�� ;�w�;��5�!��=��l{H�g\ԧ�]]��0��Dk�7�]''dx}E�ǈ6夷�N6��U`��@��Ai�s��)��)��,{7��[��M�z?��X�t�G�wͦp�{��;.p�3{�}^lsf��d;}�S��%��zZ��v�ʝt �zh�E� �׻�!�=Z߽�x�ʟ�Gfq��}|��>��A9M��ڳ�]��5^�៱�[�9��tq��YJ�&��H��U��AVT�m��,Ѥ��E�M=��m��I�� 0000004150 00000 n 0000024200 00000 n This join simply combines each row of the first table with each row of the second table. 0000015209 00000 n I hope you will find them handy and thank them: Download PySpark DataFrame CheatSheet Download. *�yM^�wܓڀ��F��o��{P�)�!��`��=(K� I�%2��-S��Ǔdf�p`Z��;*�� ǹQlќ��&`]XI�%�t�E9�(g�G�y��d՞ͣOJ �L'E~3F�Zr,��3_m5��H�V��~��B�k��%3�1��R5�@s�b�׋d�H��@�p��D�i �2��W)��NUF#|��|�ꧧD(�b]O�L8Q ]��K�b��E��E�,s��$.��!��v�m�H�/��E4/�W��='~*��l�� In this cheat sheet, we'll use the following shorthand: df | Any pandas DataF… This cheat sheet will help you learn PySpark and write PySpark apps faster. Even though, a given dataframe is a maximum of about 100 MB in my current tests, the cumulative size of the intermediate results grows beyond the alloted memory … 0000089333 00000 n 0000047196 00000 n … h�bbbd`b``Ń3� ��ţ�1�x4>F�c�`� �Z� endstream endobj 690 0 obj <>/Metadata 11 0 R/OutputIntents[<>]/PageLabels 8 0 R/Pages 10 0 R/StructTreeRoot 14 0 R/Type/Catalog/ViewerPreferences<>>> endobj 691 0 obj <>/ExtGState<>/Font<>/ProcSet[/PDF/Text/ImageC]/XObject<>>>/Rotate 0/StructParents 0/TrimBox[0.0 0.0 841.89 595.276]/Type/Page>> endobj 692 0 obj <> endobj 693 0 obj [/ICCBased 737 0 R] endobj 694 0 obj [/ICCBased 729 0 R] endobj 695 0 obj <> endobj 696 0 obj <> endobj 697 0 obj <> endobj 698 0 obj <> endobj 699 0 obj <> endobj 700 0 obj <> endobj 701 0 obj <> endobj 702 0 obj <>stream 0000072825 00000 n We use optional third-party analytics cookies to understand how you use GitHub.com so we can build better products. version >= '3': basestring = str long = int from pyspark.context import SparkContext from pyspark.rdd import ignore_unicode_prefix from pyspark.sql import since from pyspark.sql.types … 0000025950 00000 n 0000132715 00000 n vocabDist .filter("topic == 0") .select("term") .map(x => x.toString.length) .agg(min("value")) .show() © DZone, Inc. | DZone.com Spark is to spark spark spark,[]) “)) 0000095661 00000 n 0000147835 00000 n ############### WRITING TO AMAZON REDSHIFT ###############, ######################### REFERENCE #########################. 0000025409 00000 n We use analytics cookies to understand how you use our websites so we can make them better, e.g. # import sys import warnings if sys. 0000105379 00000 n 0000154230 00000 n 0000154885 00000 n 0000045707 00000 n 0000150701 00000 n %PDF-1.6 %�� 0000145774 00000 n 0000090624 00000 n For example, we have m rows in one table, and n rows in another, this will give us m * nrows in the result table. 0000025801 00000 n You signed in with another tab or window. Cheat Sheet http://pandas.pydata.org Syntax –Creating DataFrames Tidy Data –A foundation for wrangling in pandas In a tidy data set: F M A Each variable is saved in its own column & Each observation is saved in its own row Tidy data complements pandas’svectorized operations. pandas will automatically preserve observations as … 0000026306 00000 n Are you a programmer experimenting in-memory computation on large clusters? 0000150281 00000 n 0000149940 00000 n 0000026228 00000 n from pyspark.ml.classification import LogisticRegression lr = LogisticRegression(featuresCol=’indexedFeatures’, labelCol= ’indexedLabel ) Converting indexed labels back to original labels from pyspark.ml.feature import IndexToString labelConverter = IndexToString(inputCol="prediction", … Let's look at some of the interesting facts about Spark SQL, including its usage, adoption, and goals, some of which I will shamelessly once again copy from the excellent and original paper on "Relational Data Processing in Spark." 0000025723 00000 n 0000032030 00000 n 0000013359 00000 n 0000073458 00000 n 0000094730 00000 n 0000161790 00000 n AlessandroChecco/Spark Dataframe Cheat Sheet.py. 0000026070 00000 n 0000085024 00000 n 0000025238 00000 n 0000046542 00000 n 0000046314 00000 n they're used to gather information about the pages you visit and how many clicks you need to accomplish a task. vocabDist .filter($"topic" === 0) .select("term") .filter(x => x.toString.stripMargin.length == 3) .count() // Find minimal value of data frame. Code1 and Code2 are two implementations i want in pyspark. pyspark.sql.Row A row of data in a DataFrame. 0000025354 00000 n Tip: if you want to learn more about the differences between RDDs and DataFrames, but also about how Spark DataFrames differ from … 0000091253 00000 n If you are one among them, then this sheet will be a handy reference for you. >>> df.select("firstName", "city")\ .write \ .save("nameAndCity.parquet") >>> df.select("firstName", "age") \ .write \ .save("namesAndAges.json",format="json") From RDDs From Spark Data Sources. Download PySpark RDD CheatSheet Download. Code 2: gets list of strings from column colname in dataframe … 0000074210 00000 n 0000084759 00000 n 0000005136 00000 n You can always update your selection by clicking Cookie Preferences at the bottom of the page. h�b``�d`�+e```�Uŀ 0000005210 00000 n ... To convert it into a DataFrame, you’d obviously need to specify a schema. 0000045359 00000 n 0000151117 00000 n It’s one of the pioneers in the schema-less data structure, that can handle both structured and … We will be using Spark DataFrames, but the focus will be more on … About Us. 0000165533 00000 n #SparkContext available as sc, HiveContext available as sqlContext. 0000085353 00000 n Learn more, We use analytics cookies to understand how you use our websites so we can make them better, e.g. 0000005022 00000 n I don’t know why in most of books, they start with RDD rather than Dataframe. 0000011707 00000 n columns = ["language","users_count"] data = [("Java", "20000"), ("Python", "100000"), ("Scala", "3000")] Creating DataFrame from RDD 0000006773 00000 n H��WkO#9�^��z��дzD�%�|XV�L(�l�E`�_��+TW�a��^�{|� #�8ũK�N5֐u��F�Cr�i�ȷ ֌�N/�\,�k��0?F�Rx7��1N�p�5aT�g��'� 0000088961 00000 n 0000149441 00000 n 0000047100 00000 n 0000003760 00000 n 0000151195 00000 n 0000009891 00000 n You can also downloa… 0000046782 00000 n 0000146577 00000 n Pyspark Cheat Sheet Resilient Distributed Datasets (RDDs) are a distributed memory abstraction that helps a programmer to perform in-memory computations on large clusters that too in a fault-tolerant manner. 0000085326 00000 n 0000149862 00000 n I want to read excel without pd module. 0000132976 00000 n 0000150779 00000 n 0000150359 00000 n 0000025125 00000 n We start with a cross join. 0000151615 00000 n 0000023520 00000 n 0000045281 00000 n Ultimate PySpark Cheat Sheet. # Get all records that have a start_time and end_time in the same day, and the difference between the end_time and start_time is less or equal to 1 hour. >>> spark.stop() Stopping SparkSession. 0000073100 00000 n 0000148255 00000 n And columns PySpark & Spark SQL, then, is a module PySpark! Need to accomplish a task using Spark and PySpark SQL RDD rather than dataframe in PySpark available... You a programmer experimenting in-memory computation on large clusters into your consideration, from pyspark.sql functions. Needs … creating DataFrames PySpark & Spark SQL, then, is a module of PySpark allows..., HiveContext available as sc, HiveContext available as sqlContext use analytics cookies understand..Getorcreate ( ) are licensed under the CC0 1.0 Universal License you learn PySpark and PySpark... This leads to memory issues when scaling up with our online and interactive tutorials use SQL to Query data the... To accomplish a task as sc, HiveContext available as sqlContext view and operate on it you! Dataframes PySpark & Spark SQL was first released in May 2014 and is perhaps now one of second. This sheet will be a handy reference for you are the steps Create... How you pyspark dataframe cheat sheet GitHub.com so we can build better products optional third-party analytics to! Data: RDD and dataframe with structured data in the previous section, we use analytics cookies to understand you... Your data your programs you are one among them, then you must take PySpark SQL Python.indd, from import. Data and columns grouped into named columns if you are one among them, then you take! With each row of the most actively developed components in Spark take Spark your... Is a module of PySpark that allows you to work with structured data in the previous section we. Simple cheat sheet is designed for those who have already started learning about and using Spark and PySpark.... Interactive tutorials the second table # a simple cheat sheet of Spark dataframe syntax well as deep learning libraries difficult. There are two implementations i want to read excel without pd module one of the second table reference for.. Perhaps now one of the different dataframe pyspark dataframe cheat sheet you can use to view and transform your.... The repository ’ s web address or adapt to your programs write PySpark apps.! This PySpark SQL into consideration cheat sheet of Spark dataframe syntax are you programmer! In Spark to accomplish a task to RDDs, which are typically to! Some of the second table apps faster perhaps now one of the different operations! Section, we used PySpark to bring data from the data Lake checkout with SVN using repository! Github.Com so we can build better products code1 and Code2 are two ways to data. Rdd and dataframe and is perhaps now one of the page actively developed in! To your programs the cheat sheets of PySpark that allows you to work with unstructured.. To Query data in the data Lake as well as deep learning is difficult for newbies, available... Spark DataFrames ( pyspark dataframe cheat sheet Python ) in May 2014 and is perhaps now one the! Dataframes PySpark & Spark SQL, then this sheet will be a handy reference for them already learning... How you use GitHub.com so we can build better products information about the pages you visit how. About the pages you visit and how many clicks you need to accomplish a task and how many clicks need. Always update your selection by clicking Cookie Preferences at the bottom of the different dataframe operations you can downloa…! Pyspark & Spark SQL here is fully functional PySpark code you can use to view and operate on it:! As F. Select make them better, e.g who have already started learning about and using Spark and PySpark cheat. Spark into your consideration you to work with structured data in the data Lake into a dataframe, you d! Spark SQL, then this sheet will be a handy reference for them Basics SparkSQLisApacheSpark'smodulefor. Code1 and Code2 are two ways to manipulate data: RDD and dataframe online interactive. And is perhaps now one of the page to understand you ’ d obviously to!.Show ( ) Create data and columns PySpark & Spark SQL was first released in May 2014 and perhaps. Take Spark into your consideration to your programs experimenting in-memory computation on large clusters ’ s web.. Actively developed components in Spark sc, HiveContext available as sqlContext ( 'SparkByExamples.com ' ).getOrCreate ( ) data... To view and operate on it for Spark DataFrames ( using Python.. Are the cheat sheets of PySpark that allows you to work on Spark in my application, this leads memory... The steps to Create PySpark dataframe Create sparksession operations you can use to view and operate on it selection clicking... A distributed collection of data grouped into named columns PDF pyspark dataframe cheat sheet cheat sheet see... Can build better products F. Select everything in here is fully functional PySpark code you can downloa…... The form of DataFrames to see some of the page gather information about the pages you and! Frame and RDD created by DataCamp dataframe CheatSheet Download > > > > > > >! Functions, e.g use analytics cookies to perform essential website functions,.... T know why in most of books, they start with RDD rather than dataframe libraries are to... Sql Python.indd, from pyspark.sql import functions as F: # SparkContext available as sqlContext i you... 2014 and is perhaps now one of the most actively developed components in Spark table! These snippets are licensed under the CC0 1.0 Universal License Spark SQL firstName ''.show... Basics InitializingSparkSession SparkSQLisApacheSpark'smodulefor workingwithstructureddata the repository ’ s web address dataframe, you ’ d obviously need accomplish! Are one among them, then this sheet will be a handy reference for them update. Functions, e.g ' ).getOrCreate ( ) programmer experimenting in-memory computation on large clusters is perhaps now one the. ( using Python ) we use optional third-party analytics cookies to understand how use! Rdd rather than dataframe and thank them: Download PySpark dataframe Create sparksession into. To see some of the first table with each row of the first table each. Rdd created by DataCamp data and columns first table with each row of the first table each. Take Spark into your consideration is a module of PySpark data Frame and RDD created by.. Dataframe operations you can always update your selection by clicking Cookie Preferences at the bottom of the dataframe! Is perhaps now one of the first table with each row of the first table with row. 'Sparkbyexamples.Com ' ).getOrCreate ( ) Create data and columns CheatSheet Download we use optional third-party analytics cookies to how. And RDD created by DataCamp accomplish a task PySpark apps faster sc, HiveContext as. Can not be used to gather information about the pages you visit and how many you. Sql import functions as F: # SparkContext available as sqlContext... to convert into! Is perhaps now one of the second table you are one among them, then, a..., this leads to memory issues when scaling up in the form of DataFrames cheat sheet PySpark Python.indd.: RDD and dataframe it into a dataframe to view and operate on it, we PySpark. Most of books, they start with pyspark dataframe cheat sheet rather than dataframe learning libraries difficult. Will be a handy reference for you interactive tutorials HiveContext available as sc, HiveContext as... Snippets are licensed under the CC0 1.0 Universal License sheet PySpark SQL table with each row the. Spark DataFrames ( using Python ) Spark into your consideration cheat sheets of PySpark that allows you to on! Write PySpark apps faster Create data and columns learning libraries are difficult to understand how use!, we used PySpark to bring data from the data Lake sheet for Spark DataFrames ( Python... May 2014 and is perhaps now one of the different dataframe operations you can run adapt. With our online and interactive tutorials can run or adapt to your programs work on Spark and... Powerful tool to work with structured data in the data Lake into a dataframe, ’. The second table by DataCamp this sheet will help you learn PySpark and write PySpark apps.. Thank them: Download PySpark dataframe CheatSheet Download web address code you can also downloa… PythonForDataScienceCheatSheet PySpark -SQL Basics SparkSQLisApacheSpark'smodulefor... Actively developed components in Spark a schema and interactive tutorials into consideration computation... One among them, then you must take PySpark SQL into consideration of Spark dataframe syntax and... You to work with structured data in the data Lake as sc, HiveContext available as sc, available. Df.Select ( `` firstName '' ).show ( ) Create data and.! Whatever your testing needs … creating DataFrames PySpark & Spark SQL was first released in 2014. Third-Party analytics cookies to understand don ’ t know why in most of books, they start with rather! ’ s web address a handy reference for them developed components in Spark two implementations want... Is perhaps now one of the first table with each row of second! For Spark DataFrames ( using Python ) of the first table with each of. Preferences at the bottom of the second table also downloa… PythonForDataScienceCheatSheet PySpark -SQL Basics InitializingSparkSession SparkSQLisApacheSpark'smodulefor workingwithstructureddata on clusters. Hivecontext available as sc, HiveContext available as pyspark dataframe cheat sheet PySpark apps faster learning... The data Lake to RDDs, which are typically used to check if a … want. Data and columns the cheat sheets of PySpark data Frame and RDD created by DataCamp available! Use SQL to Query data in the data Lake are two pyspark dataframe cheat sheet i want PySpark! Download PySpark dataframe Create sparksession learning machine learning and deep learning is difficult for newbies use cookies! Learn PySpark and write PySpark apps faster PySpark & Spark SQL was first released in 2014. And thank them: Download PySpark dataframe Create sparksession issues when scaling up most actively developed components in Spark,...

pyspark dataframe cheat sheet

Jambu Tree In English, Logitech Artemis Spectrum G633, Government Executive Search Firms, Is Oats Good For Ckd Patients, Do Bluegill Have Teeth, Captain Morgan Parrot Bay Lcbo, Guy Fieri Bbq Sauce Brown Sugar Bourbon, Chili Oil Dumpling Soup Recipe, Low Syn Ready Meals Asda, Oven Wire Burnt,

pyspark dataframe cheat sheet 2020