Replacing Nan values with certain values from a different rowRemove rows with all or some NAs (missing values) in data.frameHow do I replace NA values with zeros in an R dataframe?Use a list of values to select rows from a pandas dataframeHow can I replace all the NaN values with Zero's in a column of a pandas dataframeHow to drop rows of Pandas DataFrame whose value in certain columns is NaNSelect rows from a DataFrame based on values in a column in pandasHow to count the NaN values in a column in pandas DataFrameHow to check if any value is NaN in a Pandas DataFrameDuplicating previous day rows for all missing dates dataframeCreating a pandas dataframe from a dictionnary and with different types of values

Most importants new papers in computational complexity

How was film developed in the late 1920s?

Golf the smallest circle!

What does grep -v "grep" mean and do?

Details of video memory access arbitration in Space Invaders

What is the difference between handcrafted and learned features

Can a police officer film me on their personal device in my own home?

How can my story take place on Earth without referring to our existing cities and countries?

Can a single server be associated with multiple domains?

Which centaur is more 'official'?

In the context of a differentiator circuit, what is a “current-sensing resistor”?

Is there reliable evidence that depleted uranium from the 1999 NATO bombing is causing cancer in Serbia?

In native German words, is Q always followed by U, as in English?

Prime parity peregrination

Can a US President have someone sent to prison?

How hard is it to sell a home which is currently mortgaged?

Welcome to my kitchen

How fast can a ship with rotating habitats be accelerated?

How to expand abbrevs without hitting another extra key?

(Higher) extensions of mixed Hodge structures

How would an order of Monks that renounce their names communicate effectively?

Can 'leave' mean 'forget'?

Was it really unprofessional of me to leave without asking for a raise first?

What could a reptilian race tell by candling their eggs?



Replacing Nan values with certain values from a different row


Remove rows with all or some NAs (missing values) in data.frameHow do I replace NA values with zeros in an R dataframe?Use a list of values to select rows from a pandas dataframeHow can I replace all the NaN values with Zero's in a column of a pandas dataframeHow to drop rows of Pandas DataFrame whose value in certain columns is NaNSelect rows from a DataFrame based on values in a column in pandasHow to count the NaN values in a column in pandas DataFrameHow to check if any value is NaN in a Pandas DataFrameDuplicating previous day rows for all missing dates dataframeCreating a pandas dataframe from a dictionnary and with different types of values






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I have a pretty large nested dictionary that has some missing values and I am trying to replace these values with values from 7 rows before it if it fits a certain condition. ffill doesn't help because it only fills with the previous value, so I tried without pandas. I'm very sure it is wrong but I honestly dont know what to do. Point of note: the [key] is a string containing a date: '2018-01-11'.
So I am pretty much trying to replace the values of the date with values from the same day but for the previous week.



All help will be appreciated



ideal= (24*60*60)/10
for day, values in (n_dict[house].items()):
count=len(values)
percentage_complete = (count/ideal_data) *100
if percentage_complete < 80:
n_dict.replace(n_dict[house][key], n_dict[house][key-7])
print(house, ',',day, ',',percentage_complete)









share|improve this question




























    0















    I have a pretty large nested dictionary that has some missing values and I am trying to replace these values with values from 7 rows before it if it fits a certain condition. ffill doesn't help because it only fills with the previous value, so I tried without pandas. I'm very sure it is wrong but I honestly dont know what to do. Point of note: the [key] is a string containing a date: '2018-01-11'.
    So I am pretty much trying to replace the values of the date with values from the same day but for the previous week.



    All help will be appreciated



    ideal= (24*60*60)/10
    for day, values in (n_dict[house].items()):
    count=len(values)
    percentage_complete = (count/ideal_data) *100
    if percentage_complete < 80:
    n_dict.replace(n_dict[house][key], n_dict[house][key-7])
    print(house, ',',day, ',',percentage_complete)









    share|improve this question
























      0












      0








      0








      I have a pretty large nested dictionary that has some missing values and I am trying to replace these values with values from 7 rows before it if it fits a certain condition. ffill doesn't help because it only fills with the previous value, so I tried without pandas. I'm very sure it is wrong but I honestly dont know what to do. Point of note: the [key] is a string containing a date: '2018-01-11'.
      So I am pretty much trying to replace the values of the date with values from the same day but for the previous week.



      All help will be appreciated



      ideal= (24*60*60)/10
      for day, values in (n_dict[house].items()):
      count=len(values)
      percentage_complete = (count/ideal_data) *100
      if percentage_complete < 80:
      n_dict.replace(n_dict[house][key], n_dict[house][key-7])
      print(house, ',',day, ',',percentage_complete)









      share|improve this question














      I have a pretty large nested dictionary that has some missing values and I am trying to replace these values with values from 7 rows before it if it fits a certain condition. ffill doesn't help because it only fills with the previous value, so I tried without pandas. I'm very sure it is wrong but I honestly dont know what to do. Point of note: the [key] is a string containing a date: '2018-01-11'.
      So I am pretty much trying to replace the values of the date with values from the same day but for the previous week.



      All help will be appreciated



      ideal= (24*60*60)/10
      for day, values in (n_dict[house].items()):
      count=len(values)
      percentage_complete = (count/ideal_data) *100
      if percentage_complete < 80:
      n_dict.replace(n_dict[house][key], n_dict[house][key-7])
      print(house, ',',day, ',',percentage_complete)






      python-3.x dataframe






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 25 at 12:29









      BuzbuzBuzbuz

      11 bronze badge




      11 bronze badge






















          0






          active

          oldest

          votes










          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55337821%2freplacing-nan-values-with-certain-values-from-a-different-row%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes




          Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.








          Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.




















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55337821%2freplacing-nan-values-with-certain-values-from-a-different-row%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

          용인 삼성생명 블루밍스 목차 통계 역대 감독 선수단 응원단 경기장 같이 보기 외부 링크 둘러보기 메뉴samsungblueminx.comeh선수 명단용인 삼성생명 블루밍스용인 삼성생명 블루밍스ehsamsungblueminx.comeheheheh

          155 수학 과학 기타 둘러보기 메뉴eh추가해eh문서를 완성해