Thursday, September 6, 2018

Slice datetime with milliseconds in Pandas dataframe

I use pandas a lot for dealing with time series. Especially the function that it could easily slice the time range you want. But recently, I need to slice between two timestamps with milliseconds, then it is not straightforward. It took me some time to figure it out (I didn't find any useful information online). Therefore, I just document it here if you have the same problem. You can find the notebook version of the blog on Qingkai's Github
import pandas as pd

First generate a dataframe with datetime as the index

Let's first generate a dataframe with datatime as the index and a counter as another column. 
## define the start and end of the time range
t0 = '2018-01-01 00:00:00.000'
t1 = '2018-01-02 00:00:00.000'

## generate the sequence with a step of 100 milliseconds
df_times = pd.date_range(t0, t1, freq = '100L', tz= "UTC")

## put this into a dataframe
df = pd.DataFrame()
df['datetime'] = df_times
df['count'] = range(len(df_times))
df = df.set_index('datetime')
df.head()
count
datetime
2018-01-01 00:00:00+00:000
2018-01-01 00:00:00.100000+00:001
2018-01-01 00:00:00.200000+00:002
2018-01-01 00:00:00.300000+00:003
2018-01-01 00:00:00.400000+00:004

Let's slice a time range

We first slice the data between two times. We can see it works well without the milliseconds in the start and end time
df['2018-01-01 00:00:00':'2018-01-01 00:00:01']
count
datetime
2018-01-01 00:00:00+00:000
2018-01-01 00:00:00.100000+00:001
2018-01-01 00:00:00.200000+00:002
2018-01-01 00:00:00.300000+00:003
2018-01-01 00:00:00.400000+00:004
2018-01-01 00:00:00.500000+00:005
2018-01-01 00:00:00.600000+00:006
2018-01-01 00:00:00.700000+00:007
2018-01-01 00:00:00.800000+00:008
2018-01-01 00:00:00.900000+00:009
2018-01-01 00:00:01+00:0010
2018-01-01 00:00:01.100000+00:0011
2018-01-01 00:00:01.200000+00:0012
2018-01-01 00:00:01.300000+00:0013
2018-01-01 00:00:01.400000+00:0014
2018-01-01 00:00:01.500000+00:0015
2018-01-01 00:00:01.600000+00:0016
2018-01-01 00:00:01.700000+00:0017
2018-01-01 00:00:01.800000+00:0018
2018-01-01 00:00:01.900000+00:0019
What if I want to slice two times with milliseconds as the following, we could see that we experience an error that has no information to help us to identify what happened. 
df['2018-01-01 00:00:00.500':'2018-01-01 00:00:01.200']
---------------------------------------------------------------------------

KeyError                                  Traceback (most recent call last)

~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/datetimes.py in slice_indexer(self, start, end, step, kind)
   1527         try:
-> 1528             return Index.slice_indexer(self, start, end, step, kind=kind)
   1529         except KeyError:


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/base.py in slice_indexer(self, start, end, step, kind)
   3456         start_slice, end_slice = self.slice_locs(start, end, step=step,
-> 3457                                                  kind=kind)
   3458 


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/base.py in slice_locs(self, start, end, step, kind)
   3657         if start is not None:
-> 3658             start_slice = self.get_slice_bound(start, 'left', kind)
   3659         if start_slice is None:


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/base.py in get_slice_bound(self, label, side, kind)
   3583         # to datetime boundary according to its resolution.
-> 3584         label = self._maybe_cast_slice_bound(label, side, kind)
   3585 


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/datetimes.py in _maybe_cast_slice_bound(self, label, side, kind)
   1480             _, parsed, reso = parse_time_string(label, freq)
-> 1481             lower, upper = self._parsed_string_to_bounds(reso, parsed)
   1482             # lower, upper form the half-open interval:


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/datetimes.py in _parsed_string_to_bounds(self, reso, parsed)
   1317         else:
-> 1318             raise KeyError
   1319 


KeyError: 


During handling of the above exception, another exception occurred:


KeyError                                  Traceback (most recent call last)

<ipython-input-4-803941334466> in <module>()
----> 1 df['2018-01-01 00:00:00.500':'2018-01-01 00:00:01.200']


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/frame.py in __getitem__(self, key)
   2125 
   2126         # see if we can slice the rows
-> 2127         indexer = convert_to_index_sliceable(self, key)
   2128         if indexer is not None:
   2129             return self._getitem_slice(indexer)


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexing.py in convert_to_index_sliceable(obj, key)
   1978     idx = obj.index
   1979     if isinstance(key, slice):
-> 1980         return idx._convert_slice_indexer(key, kind='getitem')
   1981 
   1982     elif isinstance(key, compat.string_types):


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/base.py in _convert_slice_indexer(self, key, kind)
   1462         else:
   1463             try:
-> 1464                 indexer = self.slice_indexer(start, stop, step, kind=kind)
   1465             except Exception:
   1466                 if is_index_slice:


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/datetimes.py in slice_indexer(self, start, end, step, kind)
   1536                 if start is not None:
   1537                     start_casted = self._maybe_cast_slice_bound(
-> 1538                         start, 'left', kind)
   1539                     mask = start_casted <= self
   1540 


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/datetimes.py in _maybe_cast_slice_bound(self, label, side, kind)
   1479                            getattr(self, 'inferred_freq', None))
   1480             _, parsed, reso = parse_time_string(label, freq)
-> 1481             lower, upper = self._parsed_string_to_bounds(reso, parsed)
   1482             # lower, upper form the half-open interval:
   1483             #   [parsed, parsed + 1 freq)


~/miniconda2/envs/python3/lib/python3.6/site-packages/pandas/core/indexes/datetimes.py in _parsed_string_to_bounds(self, reso, parsed)
   1316             return (Timestamp(st, tz=self.tz), Timestamp(st, tz=self.tz))
   1317         else:
-> 1318             raise KeyError
   1319 
   1320     def _partial_date_slice(self, reso, parsed, use_lhs=True, use_rhs=True):


KeyError: 

The solution

I found out an easy solution to the problem, instead of directly slice the data, we first find the index that meets our requirements, and then use the index to find the data as shown below:
ix = (df.index >= '2018-01-01 00:00:00.500') & (df.index <='2018-01-01 00:00:01.200')
df[ix]

51 comments:

  1. Thanks for the solution:) Btw. You probably should have used df.loc[...]

    ReplyDelete
    Replies
    1. Five weeks ago my boyfriend broke up with me. It all started when i went to summer camp i was trying to contact him but it was not going through. So when I came back from camp I saw him with a young lady kissing in his bed room, I was frustrated and it gave me a sleepless night. I thought he will come back to apologies but he didn't come for almost three week i was really hurt but i thank Dr.Azuka for all he did i met Dr.Azuka during my search at the internet i decided to contact him on his email dr.azukasolutionhome@gmail.com he brought my boyfriend back to me just within 48 hours i am really happy. What’s app contact : +44 7520 636249‬

      Delete
    2. REAL AND POWERFUL LOVE SPELL THAT WORK FAST AND EFFECTIVELY VISIT HIS WEBSITE: https://doctor0lovespell.wordpress.com/ 
      Hello everyone i know there is someone somewhere reading this, I want to share a great work of a spell caster called Dr 0Love my husband and i had a fight which led to our divorce but when he left me a part of me left with him and i was too sad and cried all day and night i was searching something online when i saw people testifying about Dr 0Love great work and i just decided to give him a try i did everything he told me to do and he assured me that after 24 hours my husband will come back to me, the next morning to my greatest surprised a car stopped outside my house and it was my husband i'm so happy he can also help you email him at doctor0lovespell@gmail.com or Whats-App him: +1 (201) 781-2375 you can also visit his FB page: 
      https://www.facebook.com/Lovespellthatworkfastusa

      Delete
    3. DR EMU WHO HELP PEOPLE IN ANY TYPE OF LOTTERY NUMBERS

      It is a very hard situation when playing the lottery and never won, or keep winning low fund not up to 100 bucks, i have been a victim of such a tough life, the biggest fund i have ever won was 100 bucks, and i have been playing lottery for almost 12 years now, things suddenly change the moment i came across a secret online, a testimony of a spell caster called DR EMU, who help people in any type of lottery numbers, i was not easily convinced, but i decided to give try, now i am a proud lottery winner with the help of DR EMU, i won $1,000.0000.00 and i am making this known to every one out there who have been trying all day to win the lottery, believe me this is the only way to win the lottery.

      Contact him via email Emutemple@gmail.com
      What's app +2347012841542
      Https://emutemple.wordpress.com/

      Delete
    4. Hello everyone feel free to reach out to Mr barry on Barrysilbert540 @ gmail. com  if you need help or guidance on  how  profitable trades is been done. And also if you want to recover your lost funds using his masterclass strategy he can help you. I'm earning $10,250 weekly using his masterclass.. you can also reach him out on whatsapp  + 4 4 7 5 0 8 2 9 8 6 9 1.

      Delete
  2. I like this post,And I figure that they making some incredible memories to scrutinize this post,they may take a good site to make an information,thanks for sharing it to me
    iot training in noida

    ReplyDelete
  3. It was good experience to read about dangerous punctuation. Informative for everyone looking on the subject.
    Best Data Science Courses in Hyderabad

    ReplyDelete
  4. Nice & Informative Blog !
    QuickBooks is an accounting software that has rapidly captured the global market,QuickBooks Error 2107 while working on this software. To get rid of such problems, call us at 1-855-977-7463 and get immediate support for QuickBooks issues.

    ReplyDelete
  5. Thank a lot for this informative post ,keep posting such type of wonderful post. Keep it up. If you are searching for reliable Quickbooks Error 80029c4a solution Contact us +1 877-751-0742 for instant help.

    ReplyDelete
  6. After being in relationship with Wilson for seven years,he broke up with me, I did everything possible to bring him back but all was in vain, I wanted him back so much because of the love I have for him, I begged him with everything, I made promises but he refused. I explained my problem to someone online and she suggested that I should contact a spell caster that could help me cast a spell to bring him back but I am the type that don’t believed in spell, I had no choice than to try it, I meant a spell caster called Dr Zuma zuk and I email him, and he told me there was no problem that everything will be okay before three days, that my ex will return to me before three days, he cast the spell and surprisingly in the second day, it was around 4pm. My ex called me, I was so surprised, I answered the call and all he said was that he was so sorry for everything that happened, that he wanted me to return to him, that he loves me so much. I was so happy and went to him, that was how we started living together happily again. Since then, I have made promise that anybody I know that have a relationship problem, I would be of help to such person by referring him or her to the only real and powerful spell caster who helped me with my own problem and who is different from all the fake ones out there. Anybody could need the help of the spell caster, his email: spiritualherbalisthealing@gmail.com or WhatsApp him +15068001647
    you can email him if you need his assistance in your relationship or anything. CONTACT HIM NOW FOR SOLUTION TO ALL YOUR PROBLEMS

    ReplyDelete
  7. indian porn. Therefore self-investigation is not only the most effective and efficient means to purify the mind, but also the only means by which we can achieve total purification by removing the very root of all impurities. What then remains is pure awareness, which is what we always actually are.

    ReplyDelete

  8. It WORKS! My ex blocked me on every platform. It took a while, about two months or so, but HE UNBLOCKED ME JUST A FEW HOURS AGO! Don’t give up! IT WORKS! contact Dr.Unity for help now..we are back together. Have faith in this process..Here his contact..WhatsApp him: +2348055361568 ,
    Email him at: Unityspelltemple@gmail.com
    ,
    His website:https://lovespllcaster.blogspot.com


    Amanda Lee
    NY,USA.

    ReplyDelete
  9. Am here to testify what this great spell caster done for me. i never believe in spell casting, until when i was was tempted to try it. i and my wife have been having a lot of problem living together, she will always not make me happy because she have fallen in love with another man outside our relationship, i tried my best to make sure that my wife leave this woman but the more i talk to her the more she makes me fell sad, so my marriage is now leading to divorce because she no longer gives me attention. so with all this pain and agony, i decided to contact this spell caster to see if things can work out between me and my wife again. this spell caster who was a man told me that my wife is really under a great spell that she have been charm by some magic, so he told me that he was going to make all things normal back. he did the spell on my wife and after 5 days my wife changed completely she even apologize with the way she treated me that she was not her self, i really thank this man his name is Dr ose he have bring back my wife back to me i want you all to contact him who are having any problem related to marriage issue and relationship problem he will solve it for you. his email is oseremenspelltemple@gmail.com he is a man and his great. wish you good time.
    He cast spells for different purposes like
    (1) If you want your ex back.
    (2) if you always have bad dream
    (3) You want to be promoted in your office.
    (4) You want women/men to run after you.
    (5) If you want a child.
    (6) You want to be rich.
    (7) You want to tie your husband/wife to be yours forever.
    (8) If you need financial assistance.
    (9) HIV/AIDS CURE
    (10) is the only answer to that your problem of winning the lottery

    Contact him today on oseremenspelltemple@gmail.com or whatsapp him on +2348136482342

    ReplyDelete
  10. I am James Stood from New York, United States, I am really excited about the work of DR. ZUMA, if not for him, I could have committed a suicide by now, or join my ancestors now, my wife left me with our two kids without having any misunderstanding, I tried to console her to come back to me, nothing was working out, I tried my best to have her back, I begged her, kneeled before her and begged her in tears, her no was still NO, she said she is not interested in the relationship anymore, I cried all through running up and down the streets, family relatives all to have her back because I missed her a lot mostly my children, I was not even seeing their faces at all. After a week, she brought a divorce letter to me for me to sign, I looked up and down, tears rolled down and I was frustrated, I told her, I will have to think about it. To God be all the Glory, I was directed by a friend of mine to a specialist world best known male Love Spell Caster called DR. ZUMA, I speak to her on phone, emailed each other all the time and he told me not worry about anything at all, I should relax my mind and calm down that my wife is going to come back before the week runs out, he also said he don’t charge for any of spell works, all I have to do is to provide the money needed for him to buy the materials to cast the love spell on her, I send to him and after two days he mailed and said he is done with the work, that my wife is going to come back in three days time with our children and she will kneel before me and begged in tears and promise not to leave me with any heart break again and she will cancelled the divorcement letter. I hacking into the words of DR. ZUMA and believed in him, all to my greatest surprise the words of DR. ZUMA came to pass and my wife now love me and we are now living together as one. I don’t have anything to say thank you to DR. ZUMA so I have to tell the world about him and you also can find a favor in him by contacting him on his email address spiritualherbalisthealing@gmail.com Whatsapp: +1(506)800-1647

    ReplyDelete
  11. Five weeks ago my boyfriend broke up with me. It all started when i went to summer camp i was trying to contact him but it was not going through. So when I came back from camp I saw him with a young lady kissing in his bed room, I was frustrated and it gave me a sleepless night. I thought he will come back to apologies but he didn't come for almost three week i was really hurt but i thank Dr.Azuka for all he did i met Dr.Azuka during my search at the internet i decided to contact him on his email dr.azukasolutionhome@gmail.com he brought my boyfriend back to me just within 48 hours i am really happy. What’s app contact : +44 7520 636249‬

    ReplyDelete
  12. I want you all to join me to thank the great man that help me to restoring my relationship with my husband who dump me for another Girl for 3 months, at first i never believed Dr. Twaha, will be able to help me win him back from this other Girl because i still love him and i need him back in my life, i worked and follow his instruction and it surprises me that after working with him, my husband called me and ask me to forgive and forget the past that he still love me and that was how my husband came back for good. So with this great work done for me by Dr. Twaha  Email him drlregbeyen10000gmail.com i promise to always share his good work to the whole wide world and if any body is out there passing through any relationship difficulties should kindly contact him via email: (drlregbeyen10000@gmail.com), or  Whatsapp him +2349038518881 once again thank you

    ReplyDelete
  13. Hello my name is Chloe Elizabeth I'm from USA i want to testify of a great and powerful spell caster my husband left me and the kids for 2 weeks when i called him he didn't pick up when he came back home the 3rd week he told me he wanted a divorce i was so sad i cried all night he left again i was so lonely the next day i was searching for something online when i found a spell caster called Dr Osasu who have helped so many people with their problems so i contacted him with my problems he told me it will take 24hrs and my husband will be back to me i did every thing he told me to do and the next day my husband came back kneeling and begging he canceled the divorce we are now happy together Dr Osasu can help you too Email him at

    (drosasu25@gmail.com)

    WhatsApp +2347064365391

    ReplyDelete
  14. Hello my name is Chloe Elizabeth I'm from USA i want to testify of a great and powerful spell caster my husband left me and the kids for 2 weeks when i called him he didn't pick up when he came back home the 3rd week he told me he wanted a divorce i was so sad i cried all night he left again i was so lonely the next day i was searching for something online when i found a spell caster called Dr Osasu who have helped so many people with their problems so i contacted him with my problems he told me it will take 24hrs and my husband will be back to me i did every thing he told me to do and the next day my husband came back kneeling and begging he canceled the divorce we are now happy together Dr Osasu can help you too Email him at

    (drosasu25@gmail.com)

    WhatsApp +2347064365391

    ReplyDelete
  15. REAL AND HONEST LOVE SPELL CASTER WHO RESTORED MY BROKEN MARRIAGE 

    I don’t really know how to thank Dr Jumba enough for what he has done for me. My husband left me and went back to his mistress for months. If not for the intervention of wiccalovespelltools@gmail.com , I wouldn't have gotten back my husband. His powerful reunion love spell brought back my husband the last day he finished his spiritual prayers with his Gods and oracle . I doubted him at the beginning but I realized with faith nothing Is Impossible. Thank God today I am among the people who testify about  Dr Jumba    for his good work done that restored peace back to my marriage. I will forever be grateful to God of Dr Jumba. I suggest to anyone who needs help to get In touch with Dr Jumba now through his Email ID;  [wiccalovespelltools@gmail.com] or call or text him on WhatsApp +19085174108
       website : https://drjumbaspellhome.wordpress.com    

    ReplyDelete
  16. REAL AND POWERFUL LOVE SPELL THAT WORK FAST AND EFFECTIVELY VISIT HIS WEBSITE: https://doctor0lovespell.wordpress.com/ 
    Hello everyone i know there is someone somewhere reading this, I want to share a great work of a spell caster called Dr 0Love my husband and i had a fight which led to our divorce but when he left me a part of me left with him and i was too sad and cried all day and night i was searching something online when i saw people testifying about Dr 0Love great work and i just decided to give him a try i did everything he told me to do and he assured me that after 24 hours my husband will come back to me, the next morning to my greatest surprised a car stopped outside my house and it was my husband i'm so happy he can also help you email him at doctor0lovespell@gmail.com or Whats-App him: +1 (201) 781-2375 you can also visit his FB page: 
    https://www.facebook.com/Lovespellthatworkfastusa

    ReplyDelete
  17. Good day to you, here is a quick one, just in case you are desperately in need of a trustworthy spell caster to help revive your crumbled relationship here is one that is truly versatile, compassionate and reliable when it comes to spell casting.. Doctor Egwali spelling home is the right choice for you. Contact and explain to him and I can assure you that the rest would be complete magic, my love life was on the verge of collapse until I ordered for a love spell while all due procedures were properly followed to ensure it works perfectly well. Today I'm a living witness that Doctor Egwali spell magic does work without any reasonable doubt that is why I'm using all medium to let the world know of this great Spell Doctor who brought back peace and unity to my home, Talk to him today and have your emotional setbacks wiped out totally.
    You reach him at these contacts!

    WhatsApp: +2348122948392
    Courier: dregwalispellbinder@gmail.com

    ReplyDelete
  18. I am so proud and happy to be here to share this remarkable testimony, wonderful and extraordinary, I just can't believe now my ex-husband is here with me begging for all his wrong doings, telling me how empty he felt all the while he was away, he left me and caused me so pain after a divorce that occurred 5 months ago. And this whole miracle happened immediately after I contacted Dr. Egwali for help, I am the happiest woman in the whole world today i would say' having him again by my side. It is a miracle for me and my family and eternal pleasure and merriment. I am so happy now and I do not know how much to express my gratitude and appreciation to Dr.Egwali. I would strongly recommend him if you need immediate help as it is guaranteed.
    Email him today /dregwalispellhome@gmail.com or via
    WhatsApp: +2348122948392

    ReplyDelete
  19. Hello everyone, Are you looking for a professional crypto trader, forex and binary manager who will help you trade and manager your account with good and massive amount of profit in return. you can contact Carlos Trading Signal for your investment plan, for he helped me earned 8,500usd with little investment funds. Carlos Trading Signal you're the best trader I can recommend for anyone who wants to invest and trade with a genuine trader, he also helps in recovery of loss funds..you can contact him on his Email: carlose78910@gmail.com
    Via whatsapp: (+12166263236)
    I advice you shouldn't hesitate. He's great.

    ReplyDelete
  20. My husband and I have been married for over 10 years. We met when I was 18 and he was 21. We’ve been through a lot emotionally together. There were several HUGE fights and painful situations in our marriage, but we always seemed to come out stronger on the other side. Out of the blue my husband just sprung the divorce talk on me, I was totally depressed until I found the Dr.Todd website online and I ordered a Love spell. You won’t believe my husband called me at the exact time this spell caster finished his spell work in 24hours. I was totally amazed! He is wonderful and his spells work so fast. His contact: manifestspellcast@gmail.com

    ReplyDelete
  21. I have great joy in my heart as I'm writing this testimony about the great man called Dr.John, When my lover left me, I thought i will not be able to get her back after all she has put me through, but I am so happy that after the interference of Dr.John, I was able to get my lover back within 48 hours. And I can proudly say that who ever need help in getting his lover back should contact Dr.John on these contact details below WhatsApp +1 706 871 4571, or Drjohnsoco @ gmail. com, for quicker response of what I have just witness.

    ReplyDelete
  22. I'm Tonia Anderson by name, I am from the States, Suffolk county to be precise. I am here today to testify of the good works LORD ZAKUZA has done in my life, I never knew great men still exist until I found him. I have been suffering from heart break for the past 3 years, my partner who I invested on cheated on me with my best friend on my matrimonial bed, I was yet to recover from this terrible shock until I meant LORD ZAKUZA who is a spell caster, a friend of mine directed me to him , I doubted him at first but as things went further, I had to give him my trust and did exactly as he told me to do. Ever since then, I have been happy all my life and my love life with my partner has been so wonderful. You can also need his help and here's his contact information. WhatsApp: +1 740 573 9483, Email: lordzakuza7 @ gmail. com, Website: lordzakuzaspells.com

    ReplyDelete
  23. Thank you for what you have done for me!  My husband stopped filling the divorce papers after I contacted you to help me stop the divorce with my husband and now things are going much better now.  As you said, all the process concerning the divorce have been cancelled and the evil woman that cause the problem in my marriage has be sent away by my husband and we are now happy together, if you are having relationship or marriage problems or any other problems, you can email him at: (drositamiraclespell@gmail.com) or WhatsApp him (+15088120454)
    He specialized on the following spells:

    *LOVE SPELLS
    *MARRIAGE SPELLS
    *MONEY SPELLS
    *BEAUTY SPELLS
    *WEALTH SPELLS
    *SEXUAL ATTRACTION SPELLS
    *HIV CURE SPELLS
    *CASINO SPELLS
    *REMOVE CURSE SPELLS
    *PROTECTION SPELLS
    *LOTTERY SPELLS
    *GOODLUCK SPELLS
    *FERTILITY SPELLS

    ReplyDelete
  24. I want to say thanks once again to this great man called Dr Zuma and his spiritual way of helping people i lives in USA with my husband we love each other and also he care about me always look forward to make things easy for both of us 9 years after our wedding, we both work harder to make a family greatest surprise, we have a kid after some times again, we have another one so with this, we live in peace and he was so honest to me shortly, he started misbehaving that i don’t know what is going on then i asked him. Darling what is going on? you are so strange to me this few days hope i have not offended you? he said no. Not knowing he have an affair with one lady out side who promised him a car and apartment in one estate were i cannot see him also when he cannot see me i manage to stay with him pleading him he should forgive me if i have wrong him he started complaining he has no money that he has lost all his money in his business that he needs some money then i asked him how much is this money you are looking for? he did not know i can afford it. Then, he said $14,000USD i promised him i we give it to him just for him to care about his family. My greatest surprise, the next day, i went to work and our two kids were in school not knowing his going to leave the house before i come’s back i met some of his things outside i was waiting for him to come back he never come back i cried i miss him so much and he have taking all my money away i was only left with $800USD. One day, as i was ready a blog i saw a testifier made by someone in Australia called Jessica telling people about how this man call Dr Zuma helped her and the man’s contact email was there and his mobile number then i contacted him for a help and really, he brought back my husband now am so happy my brothers and sister if you are in such relationship problem kindly via Email spiritualherbalisthealing@gmail.com or Whatsapp +15068001647 he will help you solve all your problems.

    ReplyDelete
  25. My name is Tom cam!!! i am very grateful sharing this great testimonies with you all, The best thing that has ever happened in my life, is how i worn the Powerball lottery. I do believe that someday i will win the Powerball lottery. finally my dreams came through when i contacted Dr. OSE and tell him i needed the lottery winning special numbers cause i have come a long way spending money on ticket just to make sure i win. But i never knew that winning was so easy with the help of Dr. OSE, until the day i meant the spell caster testimony online, which a lot of people has talked about that he is very powerful and has great powers in casting lottery spell, so i decided to give it a try. I emailed Dr. OSE and he did a spell and gave me the winning lottery special numbers 62, and co-incidentally I have be playing this same number for the past 23years without any winning, But believe me when I play the special number 62 this time and the draws were out i was the mega winner because the special 62 matched all five white-ball numbers as well as the Powerball, in the April 4 drawing to win the $70 million jackpot prize...… Dr. OSE, truly you are the best, with Dr. OSE you can will millions of money through lottery. i am a living testimony and so very happy i meant him, and i will forever be grateful to him...… you can Email him for your own winning special lottery numbers now oseremenspelltemple@gmail.com OR WHATSAPP him +2348136482342

    ReplyDelete
  26. It is certainly a sad thing to lose your husband or lover but you need to hold yourself in order to get your ex back, I just got my husband back through the help of genuine love spell caster called dr unity. My name is Emily Sarah am from Tx,USA. My husband left me for another woman, This was just 3 years of our marriage. The most painful thing is that I was pregnant with our second baby. I wanted him back. I did everything within my reach to bring him back but all was in vain, I wanted him back so badly because of the love I had for him, I begged him with everything, I made promises but he refused. I explained my problem to my friend and she suggested that I should rather contact a spell caster that could help me cast a spell to bring him back , I had no choice than to try it. I messaged the spell caster called dr unity, and he assured me there was no problem and that everything will be okay before 11 hours. He cast the spell and surprisingly 11 hours later my husband called me. I was so surprised, I answered the call and all he said was that he was so sorry for everything that had happened He wanted me to return to him. He also said he loved me so much. I was so happy and went to him that was how we started living together happily again.thanks to dr unity . if you are here and your Lover is turning you down, or your husband moved to another woman, do not cry anymore, contact Dr.Unity for help now..Here his contact..WhatsApp him: +2348055361568 ,
    Email him at: Unityspelltemple@gmail.com
    ,Watch this YouTube channel to know how grateful I am https://youtube.com/shorts/rBPtBktMmtA?feature=share


    ReplyDelete
  27. DR. GREAT IS THE BEST SPELL CASTER ONLINE WHO RESTORED MY BROKEN RELATIONSHIP AND I HIGHLY RECOMMENDS DR. GREAT TO ANYONE IN NEED OF HELP!
     
    My husband left me for another woman 3 months ago and ever since then my life have been filled with pains sorrow and heart break because he was my first love whom i have spent my entire life with. A friend of mine told me he saw some testimonies of a spell caster called Dr Great that he can bring back lover within some few days, i laugh it out and said i am not interested but because of the love my friend had for me, she consulted the great spell caster on my behalf and to my greatest surprise after 2 days my husband called me for the very first time after three months that he is missing me and that he is so sorry for every thing he made me went through.He came back to me and now we are happy together. I still can’t believe it, because it highly unbelievable. Thank you Dr.Great for bringing back my lover and also to my lovely friend who interceded on my behalf, for any one who might need the help of this great spell caster here is the email address:

    infinitylovespell@yahoo.com  or  infinitylovespell@gmail.com

    you can also call him or add him on Whats-app:+2348118829899
     
    View his blog  http://infinitylovespell1.blogspot.com

    ReplyDelete
  28. I've gotten back with my ex boyfriend with the help of Dr.jumba, the best spell caster online and I highly recommend Dr.jumba to anyone in need of help!.. I want to testify of how i got back my boyfriend after he breakup with me, we have been together for 3 years, recently i found out my boyfriend was having an affair with another Girl, when i confronted him, it led to quarrels and he finally broke up with me, i tried all i could to get him back but all to no avail until i saw a post in a relationship forum about a spell caster who helps people get back their lost love through Love spell, at first i doubted it but decided to give it a try, when i contacted this spell caster via his email, and he told me what to do and i did it, Then he did a Love spell for me. 28 hours later, my boyfriend really called me and told me that he misses me so much, So Amazing!! So that was how he came back that same day, with lots of love and joy, and he apologized for his mistake, and for the pain he caused me. Then from that day, our relationship was now stronger than how it were before, All thanks to DR.Jumba. he is so powerful and i decided to share my story on the Internet that Dr.Jumba real and powerful spell caster who i will always pray to live long to help his children in the time of trouble, if you are here and you need your Ex back or your husband moved to another woman, do not cry anymore, contact this powerful spell caster now. Here’s his contact: Email him at: wiccalovespelltools@gmail.com or wiccalovespelltools@yahoo.com, you can also call him or add him on WhatsApp: +19085174108 check out his website : drjumbaspellhome.wordpress.com

    ReplyDelete
  29. Thank you Dr Jumba for your genuine spells. This is really incredible, and I have never experienced anything like this in my life. Before I came in contact with Dr Jumba, I have tried every possible means that I could to get my husband back, but I actually came to realize that nothing was working out for me, and my husband had developed a lot of hatred for me.. I thought there was no hope of reuniting with my husband until my friend told me about dr jumba and she gave me dr jumba website i googled it and read good reviews about Dr Jumba work , I decided to give it a try and I did everything that he instructed me and I trusted in him and followed his instructions just as he had guaranteed me in 24 hours, and that was exactly when my husband called me and ask for forgiveness that he his on his way to my house .. We are good more than ever. Everything looks perfect and so natural! Thank you so much for your authentic and indisputable spells. Thank you Dr Jumba for your help. If you need help in your marriage or broken relationship, contact Dr Jumba right now for urgent help Email: wiccalovespelltools@gmail.com OR wiccalovelovespelltools@yahoo.com View his websitehttps://drjumbaspellhome.wordpress.com/ Call/WhatsApp him: +19085174108

    ReplyDelete
  30. i advise anyone looking for a forex and crypto trader in terms of account mentorshp to reach out to Mrs Thomas Mary for she has really help me know the better part of trade. I have made a lot of profit with her guidiance. you can reach her on her email adress thomasmary4554@gmail.com or reach her on her whatsapp +447508347797.

    ReplyDelete
  31. DR EMU WHO HELP PEOPLE IN ANY TYPE OF LOTTERY NUMBERS
    It is a very hard situation when playing the lottery and never won, or keep winning low fund not up to 100 bucks, i have been a victim of such a tough life, the biggest fund i have ever won was 100 bucks, and i have been playing lottery for almost 12 years now, things suddenly change the moment i came across a secret online, a testimony of a spell caster called dr emu, who help people in any type of lottery numbers, i was not easily convinced, but i decided to give try, now i am a proud lottery winner with the help of dr emu, i won $1,000.0000.00 and i am making this known to every one out there who have been trying all day to win the lottery, believe me this is the only way to win the lottery.

    Dr Emu can also help you fix this issues

    (1)You want your ex back.
    (2)You want to tie your husband/wife to be.
    (3)You want to be promoted in your office.
    (4)If you want a child.

    Contact him on email Emutemple@gmail.com
    What's app +2347012841542
    Website Https://emutemple.wordpress.com/
    Https://web.facebook.com/Emu-Temple-104891335203341

    ReplyDelete
  32. free bitcoin mining sites legit https://alphabitmining.com/
    bitcoin auto mining free https://alphabitmining.com/

    ReplyDelete
  33. i am giving this testimony cos l am happy My name is Mrs. Santana Valdez from Houston,taxes.i never believed in love spells or magic until i met this spell caster once. when i went to Canada in June 28th 2021 this year on a business summit. i meet a man called Dr Zuma zuk.He is powerful he could help you cast a spells to bring back my love's gone, misbehaving lover looking for some one to love you, bring back lost money and magic money spell or spell for a good job. i'm now happy & a living testimony cos the man i had wanted to marry left me 3 weeks before our wedding and my life was upside down cos our relationship has been on for 2 years. i really loved him, but his mother was against me and he had no good paying job. so when i met this spell caster, i told him what happened and explained the situation of things to him.. at first i was undecided, skeptical and doubtful, but i just gave it a try. and in 6 days when i returned to taxes, my boyfriend (is now my husband ) he called me by himself and came to me apologizing that everything had been settled with his mom and family and he got a new job interview so we should get married..i didn't believe it cos the spell caster only asked for my name and my boyfriends name and all i wanted him to do. well we are happily married now and we are expecting our little kid, and my husband also got a new job and our lives became much better. in case anyone needs the spell caster for some help, email address spiritualherbalisthealing@gmail.com Great Zuma zuk i thank you very much thank you in 1000000 times.. if not you i would have been losted and wasted thank you. Email Him Through his email address... spiritualherbalisthealing@gmail.com please make sure you contact him for any financial difficulties okay...What a powerful man such as Dr Zuma zuk.. he is so much powerful..\\ email him for any difficulties.. spiritualherbalisthealing@gmail.com His whatsapp +15068001647

    ReplyDelete
  34. I'm so very grateful to Dr oluba, for bringing my husband who left me for another woman, that moment my husband Left me I thought I lost everything until a friend of my gave me Dr oluba, WhatsApp contact, I messaged him and told him the pain I was going through so he told me that everything was going to be fine that if I have the faith and believe in him that the spell will surely work for me and my husband will surely come back home and he told me what to do, so those things were done and 24 hrs later my husband came back home begging for my forgiveness, am so happy and grateful to Dr oluba, if you need his help email him at olubasolutiontemple@gmail.com or WhatsApp him +1(518)293-0860...

    ReplyDelete
  35. Hello everyone,
    I want to say a big thank you to DR Noble for helping me get back my ex husband after 6 months of separation. It was like a dream come true when my husband came back asking for a second chance after leaving me and the kids for 6 months without communication. It took Dr Noble just 72 hours to turn things around for good in my family. Thank you Dr Noble I will forever be grateful. You can contact Dr Noble via noblesolutiontemple. com Or WhatsApp him via +2349059610643 for any spell or black magic work including spell to stop a divorce .

    ReplyDelete
  36. Lottery is something majority of the people in the world want to win, not only winning the lottery, but they want to win big, I have been playing the lottery for couple of years now, but I haven't really win big, personally I always think there is something behind all those winners who always win big, because my intense always tell me that every thing is possible, I manage to get in contact with one of the biggest lottery winner in the UK, I asked him about the success, and he referred me to a very powerful spell caster Dr.Prince he is indeed a great man who I explained to, without no hidden details , (I really want to win the lottery so bad) he put to work and few days letter he gave me numbers that never fails , these numbers was what I played and i won £3,000000,00, 3 Million pounds, is blessed , you too can change your life too with his help, contact email: obinnaspelltemple@yahoo.com
    WhatsApp him: +18488416266

    ReplyDelete
  37. #All thanks to Mr Anderson for helping with my profits and making my fifth withdrawal possible. I'm here to share an amazing life changing opportunity with you. its called Bitcoin / Forex trading options. it is a highly lucrative business which can earn you as much as $2,570 in a week from an initial investment of just $200. I am living proof of this great business opportunity. If anyone is interested in trading on bitcoin or any cryptocurrency and want a successful trade without losing notify Mr Anderson now Whatsapp: (+447883246472)
    Email: tdameritrade077@gmail.com

    ReplyDelete
  38. BEST WAYS TO GET YOUR EX LOVER BACK AND RESTORED YOUR BROKEN MARRIAGE OR RELATIONSHIP FROM SORROW TO HAPPINESS.

    Help me thank DR LARRY for helping me get my ex husband back to me and my family. This great powerful spiritual man restored my sorrow to happiness. My husband left me some years ago for another woman and they both planned to get married. I am so surprised he just came back to me one cool afternoon on Saturday, begging and crying for me to take him back and to forgive him for breaking up our marriage home and forsaking me and the children. Dr Larry is a true spiritualist savior . He brought my husband back” if you have any worries or you have any problem in your marriages or relationships you can reach him via:

    Email: assurancesolutionhome@gmail.com
    Whatapp: +1(424)-261-8520 
    website http://assurancesolutioncenter.website2.me/     
    facebook page:  https://www.facebook.com/assurancesolutionhome/

    ReplyDelete
  39. Thank you for another informative website. Where else could I get that type of information written in such an ideal way? I have a project that I’m just now working on, and I have been on the look out for such information. website link

    ReplyDelete
  40. my sister and i loves to read christian books because it inspires us to live life in its fullest* el mejor tarot del amor gratis

    ReplyDelete
  41. Please, enough of so many deceptions, they only say what each one wants to hear, many pretend to be teachers but very few really have knowledge, and stop believing that they work for free and pay after seeing results, this is totally false , I can attest to a very nice person who helped me get my husband back, he is a person who really has this gift of helping, I share his contact so that you can check for yourselves, WhatsApp: +2349046229159
    Email: dawnacuna314@gmail.com

    ReplyDelete
  42. He brought my Ex Lover back in 48 hours.... Contact Robinsonbuckler11@ gmail . com……….

    ReplyDelete
  43. I came across a website that suggested that Dr Ilekhojie can help get ex back fast. So, I felt I should give him a try. I contacted him and he told me what to do and i did it then he did a reconciliation ritual for me. 48 hours later, my husband returned home after so many months away from our home, So Amazing!! He apologized for his mistake, for the pain he caused me and the kids. Our Marriage bond is now stronger and how it was before. Thank you Dr Ilekhojie for bringing back my husband. I recommend Dr Ilekhojie for anyone who is having troubles in their marriage/relationship. Here’s his contact Call/Whats-app: +2348147400259 or Email gethelp05@gmail.com

    ReplyDelete