Script to import and do some calculations

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

Data Processing MySQL PHP Software Architecture

Project ID: #18483927

About the project

17 proposals Remote project Active 5 years ago

Awarded to:

Toreniatech

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 More

$55 USD in 3 days
(3 Reviews)
0.0

17 freelancers are bidding on average $144 for this job

gopalvora

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

$205 USD in 6 days
(521 Reviews)
8.3
schoudhary1553

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 More

$250 USD in 4 days
(266 Reviews)
7.8
abugosia

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

$222 USD in 8 days
(168 Reviews)
6.8
smsaurabhv

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

$88 USD in 3 days
(73 Reviews)
5.6
nidhicyber

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 More

$170 USD in 2 days
(11 Reviews)
5.0
cataldie

I’m an engineer, I have more than 5 years of experience on build website, app, WordPress, plugin, software. If you are looking for a professional and hard-working virtual assistant, you have found the right person! More

$88 USD in 3 days
(10 Reviews)
4.0
Shmiztech

Hi there, If it is still open i would like to give you this proposal. I have pretty good experience of 4+ years. I will be happy to work on this for you. Price can be negotiable as if you award me this. I am looking f More

$186 USD in 6 days
(8 Reviews)
3.5
ashley601

Hi, I have 6+years of rich experience with several complex and easy projects alone or with the team, I liked your project details and already done and completed successfully with offsite clients. Please share more d More

$155 USD in 3 days
(0 Reviews)
0.0
pvidhate98

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.

$150 USD in 3 days
(0 Reviews)
0.0
sk4u

Have good experience in handling databases. I love to work on data related projects. looking forward to hear from you.

$150 USD in 3 days
(0 Reviews)
0.0
onlineneelesh

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 More

$55 USD in 3 days
(0 Reviews)
0.0