Task: Transform-by-output-target-schema (source dataset: github-pipelines)

Your task is to create a data transformation pipeline in Python using pandas libraries.

Given Source Tables below, and a Target Schema provided by users that demonstrates how the desired output table should look like schematically, please write Python pandas code that can transform the Source Tables into an output table, that matches the schema/structure given by the Target Schema.  Please note that the data values in the Target Schema are intended to represent the format and layout of the output table, but may not exactly match the actual data generated from the Source Tables when the python code is run on the Source Tables.

Use operations such as merge, groupby, pivot, apply, or any appropriate python or pandas steps. Your code should save the resulting DataFrame to a CSV file named 'output.csv'. Ensure that the code is executable and can be run directly as is, in a Python environment with pandas installed.

Source Tables:


Table #1
Filename: source_0.csv
Sample Rows in Markdown:
| created             | screenname   |   followers |   favourites | text                                                                                                                                                          |
|:--------------------|:-------------|------------:|-------------:|:--------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-24 23:57:42 | dandielayla  |         263 |        53886 | b'RT @coolcam101: People trying to preorder the new iPhone\n #iPhoneX https://t.co/bA7rli39iB'                                                                |
| 2018-12-24 23:53:35 | MauraVeyne   |           0 |          107 | b'RT @aneesdadabhay: #iPhoneX internals \xf0\x9f\x92\xaa https://t.co/rnoNGXvw1O'                                                                             |
| 2018-12-24 23:53:17 | margery_pun  |           2 |          122 | b'RT @aneesdadabhay: #iPhoneX internals \xf0\x9f\x92\xaa https://t.co/rnoNGXvw1O'                                                                             |
| 2018-12-24 23:53:13 | p_effects    |         715 |        11791 | b'RT @p_effects: pink white polka dot iPhone XS case\nhttps://t.co/excHldtLJH \n#iphone #iphonecase #electronics #technology #tech\n#iPhoneX iPh\xe2\x80\xa6' |
| 2018-12-24 23:51:26 | p_effects    |         715 |        11791 | b'RT @p_effects: Blue Leopard iPhone Case\nhttps://t.co/8YoGqq4i8s \n#iphone #iphonecase #electronics #technology #tech\n#iPhoneX #iPhoneXS #iPh\xe2\x80\xa6' |
| 2018-12-24 23:48:29 | JennieJong   |           3 |          105 | b'RT @aneesdadabhay: #iPhoneX internals \xf0\x9f\x92\xaa https://t.co/rnoNGXvw1O'                                                                             |
| 2018-12-24 23:47:14 | feliparoth4  |           2 |          201 | b'RT @aneesdadabhay: Sent the #iPhoneX\xe2\x80\x99s notch to a galaxy far far away! https://t.co/lmlBcDugDj'                                                  |
| 2018-12-24 23:46:39 | looknelson   |          37 |         1855 | b'RT @coolcam101: People trying to preorder the new iPhone\n #iPhoneX https://t.co/bA7rli39iB'                                                                |
| 2018-12-24 23:45:43 | signdezballz |         102 |         2035 | b'RT @coolcam101: People trying to preorder the new iPhone\n #iPhoneX https://t.co/bA7rli39iB'                                                                |
| 2018-12-24 23:43:43 | hha_08       |           9 |           93 | b'RT @coolcam101: People trying to preorder the new iPhone\n #iPhoneX https://t.co/bA7rli39iB'                                                                |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| created             | screenname      |   followers |   favourites | text                                                                                                                                                                                                                             |
|:--------------------|:----------------|------------:|-------------:|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-19 23:58:32 | Donamezdotcom   |        2027 |          746 | b'https://t.co/raBz7HZTeI is for sale. Please contact us to purchase this domain name. #iPhone #iPhone\xe3\x82\xb1\xe3\x83\xbc\xe3\x82\xb9 #iPhoneXS\xe2\x80\xa6 https://t.co/6Yr7xUGbGS'                                        |
| 2018-12-19 23:54:47 | 96VhNExqoPbuPEC |           3 |          873 | b'RT @whitestonedome: Dome Fix for iPhone X _ Full version https://t.co/WhNRaD40Uz  @YouTube\n#DomeFixFuntion you can cover the minor scratche\xe2\x80\xa6'                                                                      |
| 2018-12-19 23:51:09 | Dana_Kral       |         252 |         9427 | b'Forecast: rain \xe2\x98\x94\xef\xb8\x8f\n\xf0\x9f\xa4\xb7\xe2\x80\x8d\xe2\x99\x80\xef\xb8\x8f I strolled along the South Bank anyway\n\n#uk #unitedkingdom #greatbritain #england #london\xe2\x80\xa6 https://t.co/897Kg1RxNa' |
| 2018-12-19 23:46:33 | leyhaaaaaaaa_   |         893 |        53936 | b'RT @9techeleven: Another version of the notchless design with an infinity-o based cut. \nDoes this look better than the notch?\n#apple #iphon\xe2\x80\xa6'                                                                     |
| 2018-12-19 23:46:00 | mellos10        |         111 |          602 | b"Win The Latest Tech available in the Market Today. one Participant will win an iPhoneX don't miss this opportunity. https://t.co/mPuGIZdDR3"                                                                                   |
| 2018-12-19 23:38:38 | iOSEden         |         940 |            5 | b'Darkroom photo editor for iPad released\nRead more \xe2\x9e\xa0 https://t.co/2mSpsIPVAW\n\n#iOS12 #iPhoneX + #iPadPro #iPadMini4\xe2\x80\xa6 https://t.co/8aRLTHyKFk'                                                          |
| 2018-12-19 23:38:13 | iPadEden        |         822 |            1 | b'Darkroom photo editor for iPad released\nRead more \xe2\x9e\x9f https://t.co/v678lfEmKR\n\n#iOS12 #iPhoneX + #iPadPro #iPadMini4\xe2\x80\xa6 https://t.co/mJdYOtp7tz'                                                          |
| 2018-12-19 23:37:09 | hazimhalimm     |       37026 |         5677 | b'RT @9techeleven: Another version of the notchless design with an infinity-o based cut. \nDoes this look better than the notch?\n#apple #iphon\xe2\x80\xa6'                                                                     |
| 2018-12-19 23:36:07 | hansnationlit   |         970 |        16507 | b'RT @9techeleven: Another version of the notchless design with an infinity-o based cut. \nDoes this look better than the notch?\n#apple #iphon\xe2\x80\xa6'                                                                     |
| 2018-12-19 23:35:10 | iAppleEden      |        1183 |            1 | b'Darkroom photo editor for iPad released\nRead more \xe2\x9e\xba https://t.co/1UFGOg8y21\n\n#iOS12 #iPhoneX + #iPadPro #iPadMini4\xe2\x80\xa6 https://t.co/a4CyZhkdJK'                                                          |


Table #3
Filename: source_2.csv
Sample Rows in Markdown:
| created             | screenname     |   followers |   favourites | text                                                                                                                                                                  |
|:--------------------|:---------------|------------:|-------------:|:----------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-16 23:59:23 | grabus_ajdin   |          33 |          131 | b'RT @AR72014: #wallpapers #iPhone \n#iPhoneXSMax #iPhoneXS #iPhoneX #iPhoneXR \n\nFragments #wallpaper for \n\n- iPhone XS MAX - iPhone XR\nhttps:\xe2\x80\xa6'      |
| 2018-12-16 23:53:09 | irish2417      |           7 |          349 | b'DONUT Pop Up Universal Mobile Phone Grip with Car Mount -(Great stocking stuffer) https://t.co/Pz2uql3uFp @eBay\xe2\x80\xa6 https://t.co/gOJ8HCWUMo'                |
| 2018-12-16 23:51:59 | irish2417      |           7 |          349 | b'Sale - Green Adhesive Silicone Credit Card Pouch For Cell Phone - https://t.co/xBg0fC7fXP @eBay #shopping #sale\xe2\x80\xa6 https://t.co/VLi31flwuu'                |
| 2018-12-16 23:51:00 | irish2417      |           7 |          349 | b'Black Adhesive Silicone Credit Card Pouch For Cell Phone -  https://t.co/jWvJL1IZe9 @eBay #shopping #sale #deals\xe2\x80\xa6 https://t.co/cWrlVWib9M'               |
| 2018-12-16 23:41:40 | rplesia26      |          12 |           84 | b'@iPhone_News The thing is, we as the consumer knew the notch was still going to be on the phone even though the scr\xe2\x80\xa6 https://t.co/q7DDoVEoPo'            |
| 2018-12-16 23:41:37 | Jason_bkroo    |        1204 |         2958 | b'Lucky to #work and #live in such a #beautiful #city #bridge #citylife #view #views #pic #picoftheday #iphonex\xe2\x80\xa6 https://t.co/bbtGRqtX8E'                  |
| 2018-12-16 23:33:28 | AndreaCoventry |        8322 |         1668 | b'RT @ucfoodietv: Hot Off the Presses! For Christmas. The TV Studio in Your Hand.  Shoot great vacation videos or create your own TV show off\xe2\x80\xa6'            |
| 2018-12-16 23:30:03 | SWIFTUNLOCK    |        1513 |           65 | b'Sim Unlock #Sprint #Boost #ATT #Tmobile iPhone X,8,7,6 #neterair #iphonex #iphone #swiftunlock #iphonex #unlockcode\xe2\x80\xa6 https://t.co/Gp8V7c7KGm'            |
| 2018-12-16 23:26:23 | NeahMhelTwenty |          18 |          334 | b'RT @AR72014: #wallpapers #iPhone #iOS #homescreen #lockscreen \n\nBlack &amp; Colors #wallpaper for \n\n- #iPhoneXSMAX\n- #iPhoneXS\n- #iPhoneX\n- #iP\xe2\x80\xa6' |
| 2018-12-16 23:26:10 | momtograndma   |       13964 |         5911 | b'RT @ucfoodietv: Winter golf trip ahead?  Use your iPhone at first.  Yes, the iPhone Improves Your Golf Game https://t.co/U9S19cCsSi #iPhone\xe2\x80\xa6'            |


Table #4
Filename: source_3.csv
Sample Rows in Markdown:
| created             | screenname      |   followers |   favourites | text                                                                                                                                                                                                                             |
|:--------------------|:----------------|------------:|-------------:|:---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-18 14:05:16 | aurondolce      |         876 |         1971 | b'RT @ankitraj2606: @ZestMoney 1:- #OnePlus6T \n2:- #POCOF1 \n3:- #oppof9pro \n4:- #ZenfoneMaxProM2 \n5:- #HonorPlay \n6:- #Realme2Pro\n7:- #Honor8\xe2\x80\xa6'                                                                 |
| 2018-12-18 14:04:48 | anzum_afia      |       90472 |       273413 | b'RT @ankitraj2606: @ZestMoney 1:- #OnePlus6T \n2:- #POCOF1 \n3:- #oppof9pro \n4:- #ZenfoneMaxProM2 \n5:- #HonorPlay \n6:- #Realme2Pro\n7:- #Honor8\xe2\x80\xa6'                                                                 |
| 2018-12-18 14:04:47 | Singh3315V      |         312 |         9524 | b'RT @ankitraj2606: @ZestMoney 1:- #OnePlus6T \n2:- #POCOF1 \n3:- #oppof9pro \n4:- #ZenfoneMaxProM2 \n5:- #HonorPlay \n6:- #Realme2Pro\n7:- #Honor8\xe2\x80\xa6'                                                                 |
| 2018-12-18 14:00:32 | cadufernandes13 |          51 |          886 | b'iPhone XR x Watch Series 4 \xe2\x8c\x9a\xef\xb8\x8f\xf0\x9f\x93\xb2\xf0\x9f\x98\x8d\n.\nTAGS: #apple #iphone #iphonex #iphonexr #iphonexs #iphonexsmax #iphoneblack\xe2\x80\xa6 https://t.co/cxb0XuP8z4'                       |
| 2018-12-18 13:58:11 | irish2417       |           7 |          349 | b'1Left - OPAL Pop Up Universal Cell Phone Grip with Clip Car Mount Included https://t.co/73oekklLI0 @eBay #shopping\xe2\x80\xa6 https://t.co/PQGs5nbTpc'                                                                        |
| 2018-12-18 13:57:23 | irish2417       |           7 |          349 | b'Sale - Black Adhesive Silicone Credit Card Pocket Pouch For Cell Phone - https://t.co/8A6nTFCQEi @eBay  #shopping\xe2\x80\xa6 https://t.co/1w7tTHSQ4a'                                                                         |
| 2018-12-18 13:55:58 | mehtadanny931   |         618 |        18335 | b'RT @ankitraj2606: @ZestMoney 1:- #OnePlus6T \n2:- #POCOF1 \n3:- #oppof9pro \n4:- #ZenfoneMaxProM2 \n5:- #HonorPlay \n6:- #Realme2Pro\n7:- #Honor8\xe2\x80\xa6'                                                                 |
| 2018-12-18 13:54:36 | Ramprasad43     |        3405 |       172137 | b'RT @ankitraj2606: @ZestMoney 1:- #OnePlus6T \n2:- #POCOF1 \n3:- #oppof9pro \n4:- #ZenfoneMaxProM2 \n5:- #HonorPlay \n6:- #Realme2Pro\n7:- #Honor8\xe2\x80\xa6'                                                                 |
| 2018-12-18 13:53:44 | JollofGadgets   |        1137 |           40 | b'iPhone X 64GB Pre Owned going @ 255k\n#swipeleft\xe2\xac\x85\xef\xb8\x8f\xe2\xac\x85\xef\xb8\x8f\xe2\xac\x85\xef\xb8\x8f\n#limitedstockavailable #ShopWithJollof \n\n08143450644 for more\xe2\x80\xa6 https://t.co/s9DLg0JIVH' |
| 2018-12-18 13:52:39 | kumar_garige    |          20 |          225 | b'RT @ankitraj2606: @ZestMoney 1:- #OnePlus6T \n2:- #POCOF1 \n3:- #oppof9pro \n4:- #ZenfoneMaxProM2 \n5:- #HonorPlay \n6:- #Realme2Pro\n7:- #Honor8\xe2\x80\xa6'                                                                 |


Table #5
Filename: source_4.csv
Sample Rows in Markdown:
| created             | screenname      |   followers |   favourites | text                                                                                                                                                               |
|:--------------------|:----------------|------------:|-------------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-25 23:59:16 | HunterRamsey00  |         164 |         7039 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:57:22 | Ebkberto        |         179 |         1601 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:57:01 | forealstevejobs |         757 |            6 | b"RT @SupplyChainBlog: VIDEO: What's in your Apple iPhone?  The Apple Supply Chain. #Supplychain #AppleSupplyChain #electronics #iPhone #iMac\xe2\x80\xa6"         |
| 2018-12-25 23:55:00 | tim_murphy55    |         435 |         8875 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:53:32 | intercotinental |         332 |         2393 | b'RT @coolcam101: People trying to preorder the new iPhone\n #iPhoneX https://t.co/bA7rli39iB'                                                                     |
| 2018-12-25 23:53:25 | EliLoibl        |          51 |           29 | b'RT @DarinAnderson75: My little brother thought he got an iPhoneX but the box had coal and a note that said he been naughty instead of the a\xe2\x80\xa6'         |
| 2018-12-25 23:52:11 | sectest9        |       22663 |            7 | b'RT @HealthyBreakApp: A break can serve as creative fuel.\nSo use Healthy Break app!\n\nhttps://t.co/o42xPaWKfP\n\n#healthy_break\n\n#cerait\n#healt\xe2\x80\xa6' |
| 2018-12-25 23:51:47 | TacoNinja021    |         118 |         3890 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:51:39 | pcmonitorss     |        1873 |            7 | b'RT @HealthyBreakApp: A break can serve as creative fuel.\nSo use Healthy Break app!\n\nhttps://t.co/o42xPaWKfP\n\n#healthy_break\n\n#cerait\n#healt\xe2\x80\xa6' |
| 2018-12-25 23:47:44 | kristyndante    |         560 |         5074 | b'RT @kristyndante: @FOX10Phoenix @USMC @USArmy @USNavy @USCG @USNationalGuard @MarForRes @Norad_Northcom Justin "Piper"\nClaris Works \nGoogle\xe2\x80\xa6'       |


Table #6
Filename: source_5.csv
Sample Rows in Markdown:
| created             | screenname    |   followers |   favourites | text                                                                                                                                                                          |
|:--------------------|:--------------|------------:|-------------:|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-22 23:59:30 | ireneaintshit |         306 |         1414 | b'My 10yr old niece has an iPhoneX. My brother is something else...'                                                                                                          |
| 2018-12-22 23:56:14 | LifeHacksIRL  |        5133 |           29 | b'#RT @TechInRL: Setup Apple Watch on Your New iPhone! https://t.co/NBoqaYbgKb #AppleWatch #AppleWatchS4\xe2\x80\xa6 https://t.co/ARwrLsxlX3'                                 |
| 2018-12-22 23:47:11 | tvoicebot     |           5 |            0 | b'iPhoneX https://t.co/NCtvp5wvCm'                                                                                                                                            |
| 2018-12-22 23:38:13 | FLai1234      |       19803 |        21254 | b'RT @FinkoPhotos: IPhone X Case\n\nGreat gift for friends and loved ones. Please follow the link below.\n\nhttps://t.co/RQs0y2dJmi\n\n#gift #iPhon\xe2\x80\xa6'              |
| 2018-12-22 23:35:22 | kristyndante  |         560 |         5074 | b'RT @kristyndante: @ColumbiaRecords @LittleMix @djsnake Justin "Piper"\nClaris Works \nGoogle Earth\nGoogle Drive\nGoogle Cloud\nGoogle Pixel 1,2\xe2\x80\xa6'               |
| 2018-12-22 23:34:29 | kristyndante  |         560 |         5074 | b'RT @kristyndante: @ZhaviaWard @FrencHMonTanA Justin "Piper"\nClaris Works \nGoogle Earth\nGoogle Drive\nGoogle Cloud\nGoogle Pixel 1,2,3\nGoogle\xe2\x80\xa6'               |
| 2018-12-22 23:34:00 | Appgik1       |        2998 |         4887 | b'RT @SleekDeals: \xf0\x9f\x94\xa5\xc2\xa0Limited Time Offer! Get Clash Royale Free! #ios #gamedev #iosgames #ClashRoyale #iphonex https://t.co/kTa3fCMq5x'                   |
| 2018-12-22 23:33:32 | Appgik1       |        2998 |         4887 | b'RT @SleekDeals: \xf0\x9f\x94\xa5 Limited Time Offer! Get Empires &amp; Puzzles Free! #ios #gamedev #iosgames #rpg #iphonex #empiregame https://t.co/28jdpYMof3'             |
| 2018-12-22 23:33:28 | Appgik1       |        2998 |         4887 | b'RT @SleekDeals: \xf0\x9f\x94\xa5 Own Harry Potter: Hogwarts Mystery Free for a Limited Time! #ios #gamedev #iosgames #HogwartsMystery #iphonex #HarryPotte\xe2\x80\xa6'     |
| 2018-12-22 23:33:05 | Appgik1       |        2998 |         4887 | b'RT @SleekDeals: \xf0\x9f\x94\xa5 Krazilla Sports Bluetooth Headphones for $19.99 (44% off)!\n\nhttps://t.co/sOGF5Qi6GH\n\n#geek #deals #tech #gamedev #home #t\xe2\x80\xa6' |


Table #7
Filename: source_6.csv
Sample Rows in Markdown:
| created             | screenname    |   followers |   favourites | text                                                                                                                                                                          |
|:--------------------|:--------------|------------:|-------------:|:------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-27 07:12:49 | D_DChris      |          32 |          127 | b'Breadth-taking sunset in San Diego #sunset #sandiego #california #cal #coronadobeach #hoteldelcoronado #coronado\xe2\x80\xa6 https://t.co/IMYJnjtkNg'                       |
| 2018-12-27 07:12:16 | prieez1312    |          38 |          833 | b'Winter sun and the bloom at parents home...shot on #iPhoneX https://t.co/0DZDjUPMf9'                                                                                        |
| 2018-12-27 07:11:28 | AigbuduE      |         723 |        10050 | b'RT @princessjoel10: Hi guys .... merry Christmas ...please I beg of u guys to  make me stand a chance win an iPhonex from @GiveawayPrism ..\xe2\x80\xa6'                    |
| 2018-12-27 07:11:12 | tnanevoCC     |         939 |         3741 | b'RT @princessjoel10: Hi guys .... merry Christmas ...please I beg of u guys to  make me stand a chance win an iPhonex from @GiveawayPrism ..\xe2\x80\xa6'                    |
| 2018-12-27 07:07:51 | abeebsilverYK |         450 |         1557 | b'RT @princessjoel10: Hi guys .... merry Christmas ...please I beg of u guys to  make me stand a chance win an iPhonex from @GiveawayPrism ..\xe2\x80\xa6'                    |
| 2018-12-27 07:07:32 | NeoAaragorn   |         979 |         1368 | b'361/365: \xe2\x80\x9cBirds\xe2\x80\x9d On A Wire. #Ag365In2018 #365photoproject #igers #instalove #instagrammers #365photochallenge\xe2\x80\xa6 https://t.co/sTwi0Yc0cM'    |
| 2018-12-27 07:05:06 | chips123lays  |          20 |          903 | b'RT @princessjoel10: Hi guys .... merry Christmas ...please I beg of u guys to  make me stand a chance win an iPhonex from @GiveawayPrism ..\xe2\x80\xa6'                    |
| 2018-12-27 07:02:19 | manukris88    |          71 |        39583 | b'RT @wallsbyjfl: City Lights - #Mobile Pack by JFL \n\nPack Download:\nhttps://t.co/UeOQF9LATO\n\nAuthor info tagged to filenames - originals via\xe2\x80\xa6'               |
| 2018-12-27 07:00:50 | Game_DevBot   |        1267 |          358 | b'RT @SleekDeals: \xf0\x9f\x94\xa5 Wow! Apple iPhone 7 Plus, GSM Unlocked, 128GB - Rose Gold for $419.88!\n\nhttps://t.co/9MU2gWW6mc\n\n#iphone #plus #iphonex #\xe2\x80\xa6' |
| 2018-12-27 07:00:31 | SleekDeals    |       14732 |         4727 | b'\xf0\x9f\x94\xa5 Wow! Apple iPhone 7 Plus, GSM Unlocked, 128GB - Rose Gold for $419.88!\n\nhttps://t.co/9MU2gWW6mc\n\n#iphone #plus\xe2\x80\xa6 https://t.co/iiLDDNE3q9'    |


Table #8
Filename: source_7.csv
Sample Rows in Markdown:
| created                   | screenname      |   followers |   favourites | text                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
|:--------------------------|:----------------|------------:|-------------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-10-30 23:59:58+00:00 | ForzaLiveryGuy  |           0 |            3 | b'I have tried both in the past, and I have always returned to apple. I see the benefits of both and neither are perfect. I am very happy with my iPhone X and Series 4 watch.'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| 2018-10-30 23:59:47+00:00 | LoudtreezTCG    |           0 |            0 | b'#MOOD A1 #Vibes #iphoneX FLEXXX .. dengee GET #money UuuU heard \xe2\x80\xa2 \xe2\x80\xa2 \xe2\x80\xa2 B.I.G .. #BIGGIE #biggiesmalls #theNotoriousBIG 1 the best 2 EVA DO IT ! #salute #almightyvision #iphone step ya\xe2\x80\xa6 https://www.instagram.com/p/Bpk1qFYH7FQ/?utm_source=ig_twitter_share&igshid=1lhbnfz7cz8or \xe2\x80\xa6'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| 2018-10-29 23:59:59+00:00 | yuka19841125    |           0 |            3 | b'#\xe3\x83\x95\xe3\x82\xa9\xe3\x83\xad\xe3\x83\xaf\xe3\x83\xbc\xe3\x81\x95\xe3\x82\x93\xe3\x81\xae\xe5\x90\x8d\xe5\x89\x8d\xe3\x81\x8c\xe5\x87\xba\xe3\x82\x8b\xe3\x81\xbe\xe3\x81\xa750\xe9\x9f\xb3 iPhone (\xc2\xb4-\xcf\x89-)\xef\xbd\xb3\xef\xbe\x91 \xe3\x81\x87\xe2\x94\x81(*\xc2\xb4\xe3\x83\xbb\xd0\xb4\xe3\x83\xbb)\xe2\x94\x81!!! \xe3\x83\xbe(\xc5\x90\xe2\x88\x80\xc5\x90\xe0\xb9\x91)\xef\xbd\xab\xef\xbe\x8a\xef\xbd\xae\xef\xbd\xab\xe2\x9c\xab\xef\xbe\x9f* \xe3\x82\xab\xe3\x83\xac\xe3\x83\xbc \xe3\x82\xad\xe3\x83\xa3\xe3\x82\xb9 \xe9\xbb\x92\xe7\x8b\x90\xe3\x81\x8f\xe3\x82\x93 \xe3\x81\x8a\xe3\x81\xa3\xef\xbc\x81\xe9\xbb\x92\xe7\x8b\x90\xe3\x81\x8f\xe3\x82\x93\xe5\x87\xba\xe3\x81\x9f!!'                                                                                                                    |
| 2018-10-29 23:59:57+00:00 | blackappleshop  |           0 |            0 | b'Case Zippo Force for Iphone 5 Rp 160.000 #BlackAppleShoppic.twitter.com/H9lrb4NZaB'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 2018-10-29 23:59:55+00:00 | MorletteFarid   |           0 |            0 | b'Un iPhone pourquoi'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 2018-10-29 23:59:55+00:00 | shigetylive     |           0 |            0 | b'\xe2\x80\x9c\xe6\xac\xa1\xe4\xb8\x96\xe4\xbb\xa3iPad Pro\xe3\x81\xaf10\xe6\x9c\x8830\xe6\x97\xa5\xe3\x81\xab\xe7\x99\xba\xe8\xa1\xa8\xe3\x80\x8111\xe6\x9c\x882\xe6\x97\xa5\xef\xbc\x88\xe9\x87\x91\xef\xbc\x89\xe7\x99\xba\xe5\xa3\xb2\xe3\x81\x8b - iPhone Mania\xe2\x80\x9d http://htn.to/Cwmwzt'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| 2018-10-29 23:59:54+00:00 | a_media_kariya  |           0 |            0 | b'UQ\xe3\x83\xa2\xe3\x83\x90\xe3\x82\xa4\xe3\x83\xab\xe3\x81\xa8WiMAX\xe5\x90\x8c\xe6\x99\x82\xe5\xa5\x91\xe7\xb4\x84\xe3\x81\xa7\xe4\xb8\x80\xe6\x8b\xac\xef\xbf\xa5\xe5\x86\x86\xef\xbc\x81\xef\xbc\x81 \xe6\x9c\x88\xe3\x80\x855572\xe5\x86\x86\xef\xbd\x9e\xe3\x81\xa72\xe5\x8f\xb0\xe6\x8c\x81\xe3\x81\xa6\xe3\x81\xa1\xe3\x82\x83\xe3\x81\x84\xe3\x81\xbe\xe3\x81\x99\xef\xbc\x88\xef\xbc\xbe\xe2\x96\xbd\xef\xbc\xbe\xef\xbc\x89 #UQ\xef\xbd\xbd\xef\xbe\x8e\xef\xbe\x9f\xef\xbd\xaf\xef\xbe\x84\xef\xbd\xb2\xef\xbd\xb5\xef\xbe\x9d\xef\xbe\x80\xef\xbd\xb3\xef\xbe\x9d\xe5\x88\x88\xe8\xb0\xb7 #au #UQ #iPhone #MNP #\xe6\xa0\xbc\xe5\xae\x89 #\xef\xbd\xbd\xef\xbe\x8f\xef\xbe\x8e #softbanku #\xef\xbe\x84\xef\xbe\x9e\xef\xbd\xba\xef\xbe\x93 #\xe6\xa9\x9f\xe7\xa8\xae\xe5\xa4\x89\xe6\x9b\xb4 #\xe4\xb8\x80\xe6\x8b\xac #CB' |
| 2018-10-29 23:59:54+00:00 | SilvisEmily1    |           0 |            4 | b'Darn why not iphone tho? can u at least try ur hardest for iphone please?????????'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| 2018-10-29 23:59:50+00:00 | AnahiBreatheUSA |           0 |            0 | b'Creo que yo tengo el iPhone m\xc3\xa1s viejito de las 3 pic.twitter.com/MDTATNYnPM'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| 2018-10-29 23:59:47+00:00 | MARASlGN        |           0 |            0 | b'@Edwin_Honoret wait, did you just lost your iphone? h-how?'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |


Target Schema:
| created             | screenname      |   followers |   favourites | text                                                                                                                                                               |
|:--------------------|:----------------|------------:|-------------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2018-12-25 23:59:16 | HunterRamsey00  |         164 |         7039 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:57:22 | Ebkberto        |         179 |         1601 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:57:01 | forealstevejobs |         757 |            6 | b"RT @SupplyChainBlog: VIDEO: What's in your Apple iPhone?  The Apple Supply Chain. #Supplychain #AppleSupplyChain #electronics #iPhone #iMac\xe2\x80\xa6"         |
| 2018-12-25 23:55:00 | tim_murphy55    |         435 |         8875 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:53:32 | intercotinental |         332 |         2393 | b'RT @coolcam101: People trying to preorder the new iPhone\n #iPhoneX https://t.co/bA7rli39iB'                                                                     |
| 2018-12-25 23:53:25 | EliLoibl        |          51 |           29 | b'RT @DarinAnderson75: My little brother thought he got an iPhoneX but the box had coal and a note that said he been naughty instead of the a\xe2\x80\xa6'         |
| 2018-12-25 23:52:11 | sectest9        |       22663 |            7 | b'RT @HealthyBreakApp: A break can serve as creative fuel.\nSo use Healthy Break app!\n\nhttps://t.co/o42xPaWKfP\n\n#healthy_break\n\n#cerait\n#healt\xe2\x80\xa6' |
| 2018-12-25 23:51:47 | TacoNinja021    |         118 |         3890 | b'RT @TrapHouseHitler: 13 year olds getting IphoneX\xe2\x80\x99s for Christmas.. when I was 13 my parents wouldn\xe2\x80\x99t even get me a RuneScape membership'  |
| 2018-12-25 23:51:39 | pcmonitorss     |        1873 |            7 | b'RT @HealthyBreakApp: A break can serve as creative fuel.\nSo use Healthy Break app!\n\nhttps://t.co/o42xPaWKfP\n\n#healthy_break\n\n#cerait\n#healt\xe2\x80\xa6' |
| 2018-12-25 23:47:44 | kristyndante    |         560 |         5074 | b'RT @kristyndante: @FOX10Phoenix @USMC @USArmy @USNavy @USCG @USNationalGuard @MarForRes @Norad_Northcom Justin "Piper"\nClaris Works \nGoogle\xe2\x80\xa6'       |

Return only the final code in markdown codeblock format, without any additional text or explanation. 



target: target.csv
train: source_0.csv
source_1.csv
source_2.csv
source_3.csv
source_4.csv
source_5.csv
source_6.csv
source_7.csv
test: test_0.csv
test_1.csv
test_2.csv
test_3.csv
test_4.csv
test_5.csv
test_6.csv
test_7.csv