March 8, 2023, LoLdle = Aphelios, Vollibear, Ryze, Senna, Shaco.March 9, 2023, LoLdle = Rumble, Braum, Sett, Renekton, Wukong.March 10, 2023, LoLdle = Sett, Shaco, Trundle, Warwick, Katarina.Query the first item purchased by each champion with a win rate greater than 0. | 0| 10.6.1| Corki| 42| Corki|the Daring Bombar.|The yordle pilot. | 0| 10.6.1| Brand| 63| Brand|the Burning Venge.|Once a tribesman. | 0| 10.6.1| Blitzcrank| 53| Blitzcrank|the Great Steam G.|Blitzcrank is an. | 0| 10.6.1|AurelionSol|136|Aurelion Sol| The Star Forger|Aurelion Sol once.| | Mana| 2| 3| 8| 7| | 0| 10.6.1| Akali| 84| Akali| the Rogue Assassin|Abandoning the Ki.| | Energy| 5| 3| 8| 7| | 0| 10.6.1| Aatrox|266| Aatrox| the Darkin Blade|Once honored defe.| |Blood Well| 8| 4| 3| 4| |colum0|version| id|key| name| title| blurb| tags| partype|info.attack|fense|info.magic|info.difficulty| Query the win rate of all champions played by each player: |zXZzJ3rOgLqEFlUzm.| Kassadin| 1| 1| 1.0| |zXZzJ3rOgLqEFlUzm.| Pantheon| 4| 4| 1.0| |zkYtjdZq7DuYLDNAt.| Gangplank| 1| 1| 1.0| |zkYtjdZq7DuYLDNAt.| Vladimir| 1| 1| 1.0|
| user|name_champion|won_matches|total_matches| win_rate| Query the win rateof all champions played by each player: explode():Returns a new row for each element in the given array.lambda(): A lambda function is a small anonymous function.distinct().collect(): distinct value in the data frame column.Arraytype(): is used to define an array data type column on DataFrame.StructField(): provides class to define the column name(String), column type.Set is created with specified number of partitions and the elements of the collection are copied to the distributed sc.parallelize(): When spark parallelize method is applied on a Collection (with elements), a new distributed data.Struct_type: PySpark provides from import StructType class to define the structure of the.So it's going to be veryĭifficult for us to extract this semi-structured The 10 players and are stored in match-recordĪs an array structure. These two sets of data contain all the data of Purpose is to help players better analyzeĢ.he goal of this project is to create an ETLĢ.From structured and semi-structured data,įind the most used items, highest win rate Process to extract data from semi-structured item_id : item_id(other data foreign key)ġ.The goal of this project is to create an ETL.key : champion_id(other data foreign key).Link of google Drive: ttps:///file/d/17y9QIiNQip326Gt23SXYFNiGNNk-bX_S/view?usp=sharing CHAMPION Participants : In-game information of 10 summoners who participated in the game League of Legends (LOL) - Ranking game 2020 Data summary match_data4 We extract data from csv and find ways to improve the winning rate of players from these data This project is to design ETL, and the data set is the ranking data of the League of Heroes.
0 kommentar(er)
