how to use a random on a certain column by using dataframe

up vote
1
down vote

favorite

I have data which will be printed in a random order but i want to perform the random operation on a perticular column
The input data will be like this:

Asset_Id    Asset Family         Asset Name Location    Asset Component     

1           Haptic Analyser      HAL1       Zenoa       Tetris Measuring Unit   

2           Haptic Analyser      HAL2       Zenoa       Micro Pressure Platform 

3           Hyperdome Inspector  HISP1      Technopolis Laser Column            

4           Nano Dial Assembler  NDA11      Zen         Fusion Tank

5           Nano Dial Assembler1 NDA12      goa         Fusion Tank1

6           Nano Dial Assembler2 NDA13      Technopolis Fusion Tank2

7           Nano Dial Assembler3 NDA14      goa         Fusion Tank3

In This input i want to apply the random operation on column "Location" other will be printed same as it is..

for this i have written a code :
This will read the csv file and print all row/column in random order

df=pd.read_csv("C:\Users\rahul\Desktop\Data_Manufacturing.csv")

ds = df.sample(frac=1)

print(ds)

But i want to apply the random operation on particular column not whole csv file
for that i have tried to access a column and get the random vaues but its not correct i guess:
This will get column "Location" values

df.iloc[:, [1]]

i tried to put in this way to get random values:

df.iloc[np.random.choice(df.index, 5),[:, [1]]

i know its not correct please tell me how to get it how do i get a particular column in a random order...any help will be appreciable..Thank you

asked Nov 21 at 18:13

snehil singh

356

1

I am a little confused on what the expected output would be, but have you tried df['Location'].sample(frac=1) If that is not your desired output, then can you please add a sample output of what your end goal will be for this piece of code.
– jtweeder
Nov 21 at 18:32

i got it.... thnx a lot
– snehil singh
Nov 22 at 4:34

@jtweeder sir I have one more doubt that want to print it with whole column means-- When i use "ds = df.sample(frac=1)" it will shuffle all the row and print it but i want another operation in that after getting all random data my column(Location) will also be shuffle
– snehil singh
Nov 22 at 4:44

@jtweeder I want to merge this both lines "ds = df.sample(frac=1)" and df['Location'].sample(frac=1) so i can get both all column in random order and one certain column in random order
– snehil singh
Nov 22 at 4:49

add a comment |

up vote
1
down vote

favorite

I have data which will be printed in a random order but i want to perform the random operation on a perticular column
The input data will be like this:

Asset_Id    Asset Family         Asset Name Location    Asset Component     

1           Haptic Analyser      HAL1       Zenoa       Tetris Measuring Unit   

2           Haptic Analyser      HAL2       Zenoa       Micro Pressure Platform 

3           Hyperdome Inspector  HISP1      Technopolis Laser Column            

4           Nano Dial Assembler  NDA11      Zen         Fusion Tank

5           Nano Dial Assembler1 NDA12      goa         Fusion Tank1

6           Nano Dial Assembler2 NDA13      Technopolis Fusion Tank2

7           Nano Dial Assembler3 NDA14      goa         Fusion Tank3

In This input i want to apply the random operation on column "Location" other will be printed same as it is..

for this i have written a code :
This will read the csv file and print all row/column in random order

df=pd.read_csv("C:\Users\rahul\Desktop\Data_Manufacturing.csv")

ds = df.sample(frac=1)

print(ds)

df.iloc[:, [1]]

i tried to put in this way to get random values:

df.iloc[np.random.choice(df.index, 5),[:, [1]]

i know its not correct please tell me how to get it how do i get a particular column in a random order...any help will be appreciable..Thank you

asked Nov 21 at 18:13

snehil singh

356

1

I am a little confused on what the expected output would be, but have you tried df['Location'].sample(frac=1) If that is not your desired output, then can you please add a sample output of what your end goal will be for this piece of code.
– jtweeder
Nov 21 at 18:32

i got it.... thnx a lot
– snehil singh
Nov 22 at 4:34

@jtweeder sir I have one more doubt that want to print it with whole column means-- When i use "ds = df.sample(frac=1)" it will shuffle all the row and print it but i want another operation in that after getting all random data my column(Location) will also be shuffle
– snehil singh
Nov 22 at 4:44

@jtweeder I want to merge this both lines "ds = df.sample(frac=1)" and df['Location'].sample(frac=1) so i can get both all column in random order and one certain column in random order
– snehil singh
Nov 22 at 4:49

add a comment |

up vote
1
down vote

favorite

I have data which will be printed in a random order but i want to perform the random operation on a perticular column
The input data will be like this:

Asset_Id    Asset Family         Asset Name Location    Asset Component     

1           Haptic Analyser      HAL1       Zenoa       Tetris Measuring Unit   

2           Haptic Analyser      HAL2       Zenoa       Micro Pressure Platform 

3           Hyperdome Inspector  HISP1      Technopolis Laser Column            

4           Nano Dial Assembler  NDA11      Zen         Fusion Tank

5           Nano Dial Assembler1 NDA12      goa         Fusion Tank1

6           Nano Dial Assembler2 NDA13      Technopolis Fusion Tank2

7           Nano Dial Assembler3 NDA14      goa         Fusion Tank3

In This input i want to apply the random operation on column "Location" other will be printed same as it is..

for this i have written a code :
This will read the csv file and print all row/column in random order

df=pd.read_csv("C:\Users\rahul\Desktop\Data_Manufacturing.csv")

ds = df.sample(frac=1)

print(ds)

df.iloc[:, [1]]

i tried to put in this way to get random values:

df.iloc[np.random.choice(df.index, 5),[:, [1]]

i know its not correct please tell me how to get it how do i get a particular column in a random order...any help will be appreciable..Thank you

asked Nov 21 at 18:13

snehil singh

356

I have data which will be printed in a random order but i want to perform the random operation on a perticular column
The input data will be like this:

Asset_Id    Asset Family         Asset Name Location    Asset Component     

1           Haptic Analyser      HAL1       Zenoa       Tetris Measuring Unit   

2           Haptic Analyser      HAL2       Zenoa       Micro Pressure Platform 

3           Hyperdome Inspector  HISP1      Technopolis Laser Column            

4           Nano Dial Assembler  NDA11      Zen         Fusion Tank

5           Nano Dial Assembler1 NDA12      goa         Fusion Tank1

6           Nano Dial Assembler2 NDA13      Technopolis Fusion Tank2

7           Nano Dial Assembler3 NDA14      goa         Fusion Tank3

In This input i want to apply the random operation on column "Location" other will be printed same as it is..

for this i have written a code :
This will read the csv file and print all row/column in random order

df=pd.read_csv("C:\Users\rahul\Desktop\Data_Manufacturing.csv")

ds = df.sample(frac=1)

print(ds)

df.iloc[:, [1]]

i tried to put in this way to get random values:

df.iloc[np.random.choice(df.index, 5),[:, [1]]

i know its not correct please tell me how to get it how do i get a particular column in a random order...any help will be appreciable..Thank you

python dataframe

asked Nov 21 at 18:13

snehil singh

356

asked Nov 21 at 18:13

snehil singh

356

asked Nov 21 at 18:13

snehil singh

356

asked Nov 21 at 18:13

snehil singh

356

asked Nov 21 at 18:13

snehil singh

356

1

I am a little confused on what the expected output would be, but have you tried df['Location'].sample(frac=1) If that is not your desired output, then can you please add a sample output of what your end goal will be for this piece of code.
– jtweeder
Nov 21 at 18:32

i got it.... thnx a lot
– snehil singh
Nov 22 at 4:34

@jtweeder sir I have one more doubt that want to print it with whole column means-- When i use "ds = df.sample(frac=1)" it will shuffle all the row and print it but i want another operation in that after getting all random data my column(Location) will also be shuffle
– snehil singh
Nov 22 at 4:44

@jtweeder I want to merge this both lines "ds = df.sample(frac=1)" and df['Location'].sample(frac=1) so i can get both all column in random order and one certain column in random order
– snehil singh
Nov 22 at 4:49

add a comment |

1

I am a little confused on what the expected output would be, but have you tried df['Location'].sample(frac=1) If that is not your desired output, then can you please add a sample output of what your end goal will be for this piece of code.
– jtweeder
Nov 21 at 18:32

i got it.... thnx a lot
– snehil singh
Nov 22 at 4:34

@jtweeder sir I have one more doubt that want to print it with whole column means-- When i use "ds = df.sample(frac=1)" it will shuffle all the row and print it but i want another operation in that after getting all random data my column(Location) will also be shuffle
– snehil singh
Nov 22 at 4:44

@jtweeder I want to merge this both lines "ds = df.sample(frac=1)" and df['Location'].sample(frac=1) so i can get both all column in random order and one certain column in random order
– snehil singh
Nov 22 at 4:49

I am a little confused on what the expected output would be, but have you tried df['Location'].sample(frac=1) If that is not your desired output, then can you please add a sample output of what your end goal will be for this piece of code.
– jtweeder
Nov 21 at 18:32

i got it.... thnx a lot
– snehil singh
Nov 22 at 4:34

@jtweeder sir I have one more doubt that want to print it with whole column means-- When i use "ds = df.sample(frac=1)" it will shuffle all the row and print it but i want another operation in that after getting all random data my column(Location) will also be shuffle
– snehil singh
Nov 22 at 4:44

@jtweeder I want to merge this both lines "ds = df.sample(frac=1)" and df['Location'].sample(frac=1) so i can get both all column in random order and one certain column in random order
– snehil singh
Nov 22 at 4:49

add a comment |

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',
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

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418232%2fhow-to-use-a-random-on-a-certain-column-by-using-dataframe%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

active

oldest

votes

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.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

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

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Btukfyl