Mixing
how to use a random on a certain column by using dataframe
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
python dataframe
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
add a comment |
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
python dataframe
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
1
I am a little confused on what the expected output would be, but have you trieddf['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 '18 at 18:32
i got it.... thnx a lot
– snehil singh
Nov 22 '18 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 '18 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 '18 at 4:49
add a comment |
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
python dataframe
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
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
python dataframe
python dataframe
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
asked Nov 21 '18 at 18:13
snehil singhsnehil singh
1459
1459
1
I am a little confused on what the expected output would be, but have you trieddf['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 '18 at 18:32
i got it.... thnx a lot
– snehil singh
Nov 22 '18 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 '18 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 '18 at 4:49
add a comment |
1
I am a little confused on what the expected output would be, but have you trieddf['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 '18 at 18:32
i got it.... thnx a lot
– snehil singh
Nov 22 '18 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 '18 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 '18 at 4:49
1
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 '18 at 18:32
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 '18 at 18:32
i got it.... thnx a lot
– snehil singh
Nov 22 '18 at 4:34
i got it.... thnx a lot
– snehil singh
Nov 22 '18 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 '18 at 4:44
@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 '18 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 '18 at 4:49
@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 '18 at 4:49
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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 '18 at 18:32
i got it.... thnx a lot
– snehil singh
Nov 22 '18 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 '18 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 '18 at 4:49