Script to import and do some calculations
$30-250 USD
着払い
I have this three tables that I want to be joined in one table in MySQL
Want to join them into a big one where
tg_user_id.0 = _id in (in C table)
tg_channel_id.0 = id (in B table)
when have in DB
- want be able to make selection of daily, weekly and monthly exports to csv.
- want be able to make reports with most active posters in one channel or all channels, who posted in most channels, what channels as most posting, identify top keyword and phrases.
a) looking like this 4B+ rows
tg_message_id.0,tg_user_id.0,tg_channel_id.0,tg_created_at.0,message_info.0,message.0
1,1000735619,1000735619,2015-10-24 14:13:23,MessageActionChannelCreate,
4,1000735619,1000735619,2015-10-24 14:17:24,MessageActionChatEditPhoto,
5,1000735619,1000735619,2015-10-24 14:21:17,MessageActionChatEditTitle,
6,1000735619,1000735619,2015-10-24 14:28:00,MessageActionChatEditTitle,
8,1000735619,1000735619,2015-10-24 15:05:53,Message,"Official Bitcoin Wednesday Post:
[login to view URL]"
11,1000735619,1000735619,2015-10-25 05:35:52,Message,"Dash “Social Media” + Dash “Chat Groups” Listings (Oct 2015)
B) Channels (6000 rows)
id,_index,_score,_type,username,verified,title,deactivated,migrated_to,participants_count,access_hash,date,type
1125305340,telegram_channels,1.0,channels,MaverickChain,False,Maverick Chain,,,,5744886132890520676,2018-11-30 17:15:09,megagroup
1239131278,telegram_channels,1.0,channels,plair_life,False,Plair Life,,,,-3443918625518008256,2018-11-21 16:29:48,megagroup
1160870009,telegram_channels,1.0,channels,MainframeCommunity,False,Mainframe Community (1/2),,,,-8354637651801840590,2018-11-30 16:51:54,megagroup
1197924701,telegram_channels,1.0,channels,suchapp,False,SuchApp,,,,4684335843207338114,2018-11-30 18:41:19,megagroup
1296280366,telegram_channels,1.0,channels,MobileBridge_CN,False,MobileBridge Momentum 中文官方群,,,,2016284963887309480,2018-11-30 17:00:09,megagroup
1197678716,telegram_channels,1.0,channels,cashbetcoin,False,CashBet Coin,,,,-3714975924910041580,2018-11-23 09:53:03,megagroup
C) users (I think
_id,_index,_score,_type,username,first_name,last_name,verified,deleted,bot,phone,access_hash,lang_code
526610448,telegram_users,1.0,users,None,None,None,False,True,False,None,2534333162737127505,None
470570877,telegram_users,1.0,users,Knespolow1,Donest,None,False,False,False,None,-1068180460076032612,None
567443401,telegram_users,1.0,users,TraVinh236,Vinh,Nguyen,False,False,False,None,-8982158329852274615,None
603166761,telegram_users,1.0,users,Jojonati,Jubril,None,False,False,False,None,-5084904993892111936,None
698989476,telegram_users,1.0,users,None,idjdj,ksodb,False,False,False,None,-2691892672563827517,None
499958318,telegram_users,1.0,users,qsbbrrrmqz,本,宋,False,False,False,None,483967380131258215,None
103959584,telegram_users,1.0,users,BredaFichasOnline,Breda -,Fichas Online,False,False,False,None,-7396599628519213975,None
313728089,telegram_users,1.0,users,None,None,None,False,True,False,None,4848047923339588607,None
34465965,telegram_users,1.0,users,None,Davide,None,False,False,False,None,1782572651805387305,None
499072444,telegram_users,1.0,users,None,None,None,False,True,False,None,5136323161938630476,None
572170371,telegram_users,1.0,users,None,None,None,False,True,False,None,1540886158472463572,None
440145863,telegram_users,1.0,users,Richmanjm,Kevin,Richards,False,False,False,None,-8904596635254789834,None
プロジェクトID: #18483927
プロジェクトについて
アワード:
Hello Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. As per your requirement, I would like to tell you that we have very strong experience of もっと
17人のフリーランサーが、平均$144 で、この仕事に入札しています。
Hello i hope you are fine . i just review your requirement . i can help you to make Script to import and do some calculations lets discuss related requirement and make deal with it . Thanks
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl もっと
Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
Hi, I have gone through your requirement to for the database works . i can do your work . i understand mysql very well as well as various other no-sql and sql databases
Hello, I am a professional Web Developer /Designer and I have read your details and I understood your requirement, I believe I am a good fit for this project, I can make Script import and do some calculations, I hav もっと
Hi, I have 3+ years of experience in php. So I am very familiar with mysql. I have done may projects in codeigntor, laravel & WordPress. Please feel free to contact me if you have any query.
Have good experience in handling databases. I love to work on data related projects. looking forward to hear from you.
Hello Sir , I'm Neelesh Chourasiya. I understood what you want to do. I can do it much better. Hire me and give a opportunity for start my career as a freelancer. I'll never disappoint you. See you in Message box. T もっと