Skip to content

Instantly share code, notes, and snippets.

View apogiatzis's full-sized avatar
:electron:
Stay awhile and listen.

APogiatzis apogiatzis

:electron:
Stay awhile and listen.
View GitHub Profile
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 6 columns, instead of 3. in line 7.
obj_id,amount,owner,currency,recipient,timestamp
a171081d-b910-47c3-b400-f54c5d159b7c,3012.520326499339,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,80544cb9-b281-45c3-b4c3-985f1a8ac847,2014-09-20 23:15:35
87329ee1-ff6c-4989-8ad4-6558b9a92fc8,2397.429076329954,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,4f05b1f2-9aec-48e2-b1ce-0d1cee31a969,2014-09-21 00:15:35
475f483c-87a5-4290-bd08-ea31aee834eb,7471.771387165544,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,b57a519e-58b4-4448-a415-4c10ea3bff76,2014-09-21 01:15:35
60a366bb-56c8-4d20-8612-62462a3a7ca2,8404.497519509043,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,c7a90ae7-8a94-4ad1-b114-d52b411b0b2a,2014-09-21 02:15:35
b78d97db-8ed8-44f2-ad4a-f1084942ac06,3160.252473111225,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,23332453-381e-4542-9841-66e8ca2f4a8a,2014-09-21 03:15:35
7ff7eb2e-6c2b-45b0-bb39-39b747a5c1d9,6098.609201828923,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,5dee4ac7-7378-4147-bf72-f3e8df240b68,2014-09-21 04:15:35
b8bf566c-5af5-4023-a889-8177bb16ac59,7904.390599685095,ba
obj_id amount currency recipient timestamp
c3684828-fca3-47fe-b438-198a5e0a52db 141365.0 GBP bab6ff99-a25e-4d5c-8bb5-769dfd7799ae 2014-09-16 22:15:35
58499457-abe3-4291-9f52-3daec8a3f8c3 144375.0 GBP 63e5d001-06c4-4c61-8e5c-adf6c71d3fae 2015-09-16 11:59:12
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 6 columns, instead of 4. in line 8.
obj_id,balance,currency,owners,bank,opened_at
5032bafa-4641-476d-b9f0-b4d94d181aa7,5182.1738748835505,GBP,63e5d001-06c4-4c61-8e5c-adf6c71d3fae,Barclays,2019-08-20 09:41:56
bdbccd63-c521-4c54-946f-ee3c14eda434,31215.637395712656,GBP,1f362952-2004-4ba5-a436-3094212b8013,HSBC,2013-07-15 10:27:05
0506bfa7-626b-43ce-b06a-d48e2b9b796a,1337.8565290857598,GBP,b325f325-349b-4cf0-88a4-4becfad61310,Lloyds Banking Group,1993-03-01 22:31:55
e0150719-ab46-4b5e-891e-ddf026e5a1a6,9145.970496204713,GBP,bfef9b63-e83e-476a-81df-89b24b1d32cd,HSBC,2018-07-28 01:28:29
c2eccf2d-6279-4edc-b586-ccc700b94316,26.434749463574057,GBP,7d0889e1-dc79-4212-ad01-6f93d5d67dc8,HSBC,2013-11-22 14:47:47
61d284c7-9f32-4c98-a4a5-bd86530a40fe,12055.0285816817,GBP,23332453-381e-4542-9841-66e8ca2f4a8a,Royal Bank of Scotland,2014-05-02 01:09:01
cc8c69fe-c672-4004-bf97-34ed59d77d7c,19268.41108098035,GBP,667a42a8-b4c3-4e83-a7e9-86950a084c4b,NatWest,2008-03-08 02:59:08
befbee72-df70-4f02-9fa2-1bdedc7963eb,386.7139309481009,GBP,42a24287-f541-49f0-8918-e81d
obj_id amount currency sender recipient type timestamp
83de3990-9292-4e2f-b3f9-29298bfd30e7 8297.26919178327 GBP 5032bafa-4641-476d-b9f0-b4d94d181aa7 309170fe-77e1-4d35-95c1-1ae4d5f96712 TRANSFER 2020-02-07 13:42:42
b520abea-f139-4869-a044-70e2cb5d3be9 4741.819187246722 GBP e989b38f-41a0-4562-a7c5-c94b84b18074 dd06213c-d4a4-43ca-9f6f-2d7ccd540334 TRANSFER 2021-01-03 12:29:40
048424e8-aee5-442d-ac69-fd9af3792df5 1434.7613936628347 GBP 11849051-1fa8-4da6-8419-74c709a3434b f071b9a9-8eae-434e-84d7-f59baa2a24e7 TRANSFER 2021-12-02 23:04:16
7d9f4507-5c32-452a-8ebe-b5070492fdef 7343.383225824531 GBP 30f6ba08-ec1e-4ba2-8c77-81e6b1b7a62d d8f491bd-4f63-419d-8f58-89883951456b TRANSFER 2020-10-21 23:38:50
5bdcca63-17f3-4cd1-948f-8fd8750573b9 3969.6346440750895 GBP 11dbf645-5bf7-4479-9eb1-4d6a78ee0878 11dbf645-5bf7-4479-9eb1-4d6a78ee0878 TRANSFER 2021-12-05 09:40:18
9fe06993-ccbf-4456-9c8c-aad7f4529cc3 5778.174746535905 GBP d8f491bd-4f63-419d-8f58-89883951456b 30f6ba08-ec1e-4ba2-8c77-81e6b1b7a62d TRANSFER 2021-04-01 22:44
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 7 columns, instead of 1. in line 7.
obj_id,amount,currency,sender,recipient,type,timestamp
c0017c27-ab73-4029-8330-5ac72a3826c2,2889.4697311261652,GBP,d45d49f6-c23f-4f41-b520-c1bbd7f463cc,dfa672ee-aef1-47bd-a7a8-e15651bc4f29,DEPOSIT,2020-08-14 09:29:07
78c32f40-3d02-43a6-b4de-0cc0f09e0f66,4942.411954937588,GBP,20b1da10-404d-437f-885c-1fe19f96ebf9,9f6187bd-97f1-4c9a-b127-97a51d6f687a,DEPOSIT,2017-12-21 04:50:03
d1d2d120-6a48-4235-a346-d6cc74f5ad15,26069.262308789504,GBP,a5d78208-ad07-4783-9d0b-9dc7ea9b2009,009a8cb9-3988-42cf-a7ec-d3aa90e94207,DEPOSIT,2022-01-26 00:51:01
cb822199-2d02-4921-ab7f-1fe6390f1c34,19793.024645699916,GBP,2b41bf16-2fa8-4ba5-9d63-5bbb5b43ea93,309170fe-77e1-4d35-95c1-1ae4d5f96712,DEPOSIT,2018-10-02 01:02:37
30907626-3e4e-44f1-a40c-d1db780d55b7,9801.845155065861,GBP,8a325c51-3b79-433d-90e2-d69ffac3609f,99fcdd05-65c3-442c-a343-da7ad7a61fad,DEPOSIT,2017-05-13 08:29:00
688eaf83-50b6-4926-8b2f-838864d998a8,8518.70601847095,GBP,b57a519e-58b4-4448-a415-4c10ea3bff76,30f7f188-fe96-439e-a218-d0d4c932af5e,DEPOSIT,2018-11-18 13:08:45
7
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 9 columns, instead of 5. in line 7.
obj_id,first_name,last_name,date_of_birth,occupation,nationality,phone,email,ni_number
4a7edb39-029f-40a1-8fef-7ddff72537ce,Emma,Reed,1998-08-15,Architect,Eritrea,+44(0)161 4960764,nevans@hotmail.co.uk,ZZ 42 19 48 T
682a5412-07dd-4215-be8d-aee30df50be4,Diana,Barker,1980-01-01,Insurance claims handler,Bolivia,+441632 960 157,nixonguy@hotmail.co.uk,ZZ 387784 T
5d73ead8-5cee-47ce-8692-403fe511e07d,Benjamin,Nelson,1970-12-16,Chief Financial Officer,Saint Helena,+44(0)8081570609,vfinch@yahoo.com,ZZ 513933 T
f61040ff-c30c-4d1c-acb3-5417b2bd95b2,Patrick,Roberts,2000-06-26,"Chemist, analytical",Belgium,+44(0)121 496 0871,lynn41@hotmail.co.uk,ZZ839894T
962f7070-cffb-4b45-8fcb-2af9b88063a3,Louise,Green,1996-03-11,Investment analyst,Montserrat,0118 4960423,ryanosborne@outlook.com,ZZ711220T
7babbe46-c714-44d0-9a52-192bf6e604db,Jonathan,Sutton,1996-08-17,"Scientist, water quality",Falkland Islands (Malvinas),0191 4960339,cjackson@yahoo.co.uk,ZZ 515917 T
905368ca-b852-4bae-837c-8faffb66579f,Kate,Yates,1982-12-15,Financial
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 6 columns, instead of 2. in line 8.
obj_id,balance,currency,owners,bank,opened_at
8f912e95-a127-469d-b416-5237eb4f8abb,5787.342044550753,GBP,4a7edb39-029f-40a1-8fef-7ddff72537ce,Co-operative Bank,2018-04-10 00:36:44
25b093b4-e6aa-40c7-8c03-5991f0843744,7967.470665633736,GBP,682a5412-07dd-4215-be8d-aee30df50be4,Lloyds Banking Group,2003-02-04 01:50:31
89f33950-6b0e-4310-a751-d169ff12415e,9128.136912370079,GBP,5d73ead8-5cee-47ce-8692-403fe511e07d,Co-operative Bank,2012-11-04 21:18:02
0651c053-69c5-4c89-a959-04004b1af6ef,4158.837239751703,GBP,f61040ff-c30c-4d1c-acb3-5417b2bd95b2,Lloyds Banking Group,2016-10-11 23:45:09
577a6f0c-0fbe-48be-9c71-a7dd7a264ba2,3889.477255052483,GBP,962f7070-cffb-4b45-8fcb-2af9b88063a3,Royal Bank of Scotland,2016-09-19 11:33:58
e3f538c2-bc5b-4def-92ae-0a9c94698213,19033.734115247018,GBP,7babbe46-c714-44d0-9a52-192bf6e604db,Lloyds Banking Group,2013-01-21 10:05:48
9ad13c27-52ad-4932-b96d-1f714620cc25,5658.602453620952,GBP,905368ca-b852-4bae-837c-8faffb66579f,HSBC,2018-09-23 22:01:57
7a28a2be-b72a-452f-a50d-735dc06cfde9,1
obj_id amount currency sender recipient type timestamp
86822a80-fd2e-481b-a572-064bb8bdde2b 33070.0771947208 GBP ab69ea89-888a-49c5-bc29-2152bf640139 8751ba4a-b53d-4cad-afaa-e6cae0e4a08d TRANSFER 2021-09-07 14:10:00
2fd4315f-807b-49b7-9b94-cd7c3a7147d0 3806.9101883916524 GBP 44943fd7-30ae-48df-8cc9-e0851c3b85a0 4ba25847-9f04-44d1-99ed-a6c506d7e64f TRANSFER 2018-04-17 07:48:59
3f00285e-eb48-41e5-99db-dbbc59987eef 1141.6629621084373 GBP 6900aaba-5635-4747-afd9-714f5b2c521d a161eac4-736d-4950-bdc4-0ead2e6c8638 TRANSFER 2021-01-14 18:25:58
d9684a41-1a2a-4015-a9c4-7e5d56540d09 622.9774963147655 GBP 6a4e60b8-76f5-4676-bb21-e942b3b72779 1bdd38e0-1ab8-49a5-b42d-360201a05ffc TRANSFER 2022-01-13 18:48:02
bdaa6b01-6fc6-4ec6-9db5-8b5d90c72d55 26489.162040911215 GBP be1049b6-c04d-4f36-bf65-2e05b0196562 4b944683-e879-4407-8e17-50d683344334 TRANSFER 2021-09-24 13:07:54
6696471a-4ea4-46c2-9677-7de571ebcfae 3646.2037853976017 GBP d7a1b0c5-5c2b-4ba8-984f-ad391ada3e88 6a4e60b8-76f5-4676-bb21-e942b3b72779 TRANSFER 2022-01-22 11:
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 7 columns, instead of 1. in line 7.
obj_id,amount,currency,sender,recipient,type,timestamp
6cf5e4ce-f86f-4afe-aeb0-c2326ff029cb,7665.170613059853,GBP,1980acb6-aff2-4c5b-bfc6-3438f1417549,7b5d1e40-7440-4e06-b5ca-d778cd1e8408,DEPOSIT,2015-02-20 18:37:22
d064585f-e52b-4fd3-86af-22938c595921,9358.878986309915,GBP,94d61090-a2d1-4411-895d-2ef68c4d2575,1bdd38e0-1ab8-49a5-b42d-360201a05ffc,DEPOSIT,2006-07-09 22:01:55
eb10e133-1d33-4f9f-861c-fb16852fc9e2,3142.837660720443,GBP,2ad14cca-3df0-447e-afdc-6e955e612066,d96f5712-a241-4735-9713-4fafaed5b6e2,DEPOSIT,2021-12-25 13:18:04
e633f4ca-5008-4a20-aed6-cc7b3d32931e,3556.692533622588,GBP,b514e44e-a965-4b33-9710-aec9e808e515,7a28a2be-b72a-452f-a50d-735dc06cfde9,DEPOSIT,2012-11-11 10:52:02
90ec3da3-9132-40cd-9dec-6e1aceb38a65,21781.068302337146,GBP,888a9e0a-0022-49b3-a912-f63fe26f893a,c9145959-f8e5-4b79-bf23-7a998f62dcef,DEPOSIT,2022-01-14 06:47:36
98a1be18-f578-4d29-88aa-845daf09a355,16583.91026959208,GBP,f5c5c86e-9c8a-4d42-b3bc-8a0532efd365,17ae2126-a087-40c1-bce9-7a2506368824,DEPOSIT,2015-09-26 23:33:55
80
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 6 columns, instead of 2. in line 7.
obj_id,amount,owner,currency,recipient,timestamp
e64ebdf6-e817-4c37-9748-8ae815fb5f11,3871.6694263723557,34ec8942-31a0-424e-8ed0-e55b122003ed,GBP,1ee4ef75-c652-4a08-9ad5-d1fd7d7a3f4d,2008-11-09 23:39:01
fdbefc8a-4ead-45b6-85ef-217f0100931c,3261.5048988495428,34ec8942-31a0-424e-8ed0-e55b122003ed,GBP,cc0f14c6-8aa0-4f8f-be40-4378451734b7,2008-11-10 00:39:01
68683f2b-4444-4882-a134-0166b75303ed,4561.147291031659,34ec8942-31a0-424e-8ed0-e55b122003ed,GBP,173ab2c7-f8db-4473-a69d-a2b5ab74f62c,2008-11-10 01:39:01
b7ce7df2-39ec-4ae5-afb6-c5f5214656c6,8374.805243059569,34ec8942-31a0-424e-8ed0-e55b122003ed,GBP,65cd6373-a698-4d6d-b315-a888887d02f0,2008-11-10 02:39:01
12e9bd3a-0a13-4e6f-9392-ff97e423e83c,3666.9314627356953,34ec8942-31a0-424e-8ed0-e55b122003ed,GBP,11d727b9-fb78-44c5-a4cc-ded1c2aef018,2008-11-10 03:39:01
45a32086-cc49-4dec-b53e-c701b60fe8f5,2968.7309175742807,34ec8942-31a0-424e-8ed0-e55b122003ed,GBP,c6cecf54-094c-4892-a654-501fa145d018,2008-11-10 04:39:01
96b09610-9fdf-4967-a2c2-6f8f24b40402,8439.84872442190